[Solved] Missing values for 'dimension' were not filled. It is unclear what values to fill for this field

[jimRL]

So I have these lines that create cohorts:

dimension: loan_purpose2 {
label: “Purpose”
sql: CASE WHEN ${TABLE}.loan_prps != 03
THEN ‘Purchase’
WHEN ${TABLE}.loan_prps = 03 and ${TABLE}.cash_out_refi_ind = ‘Y’
THEN ‘Cash-Out Refinance’
WHEN (${TABLE}.loan_prps = 03 and ${TABLE}.cash_out_refi_ind = ‘N’) OR (${TABLE}.loan_prps = 03 and ${TABLE}.cash_out_refi_ind IS NULL)
THEN ‘No Cash-Out Refinance’
ELSE NULL
END ;;
}

And when I run it in a query it results in the Warning:

Missing values for ‘mortgage_data_warehouse.loan_purpose2’ were not filled. It is unclear what values to fill for this field.

And it doesn’t show the ‘Unknown’ bucket. Why is it not picking up the unknown?

Thank you!

Solved