I have this in my in-database formula tool but it's error with no columns returned. I assume that I'm not putting it into a format it likes.
Any help?
Solved! Go to Solution.
In-DB operates using a
CASE WHEN ... THEN ... WHEN... THEN ... ELSE... END
syntax.
Thank you so much.
This worked:
CASE
WHEN "PRVDR_ID_NO" <> 0 and "ADDR_NO" = 0 and "RMBRCP_TAXID_NO" = 0 THEN 'PIN_Only'
WHEN "PRVDR_ID_NO" <> 0 and "ADDR_NO" <> 0 and "RMBRCP_TAXID_NO" = 0 THEN 'PIN_Address'
WHEN "PRVDR_ID_NO" <> 0 and "ADDR_NO" <> 0 and "RMBRCP_TAXID_NO" <> 0 THEN 'PIN_Address_Tin'
WHEN "PRVDR_ID_NO" = 0 and "ADDR_NO" <> 0 and "RMBRCP_TAXID_NO" = 0 THEN 'Address_Only'
WHEN "PRVDR_ID_NO" = 0 and "ADDR_NO" <> 0 and "RMBRCP_TAXID_NO" <> 0 THEN 'Address_Tin'
WHEN "PRVDR_ID_NO" = 0 and "ADDR_NO" = 0 and "RMBRCP_TAXID_NO" <> 0 THEN 'Tin_Only'
WHEN "PRVDR_ID_NO" <> 0 and "ADDR_NO" = 0 and "RMBRCP_TAXID_NO" <> 0 THEN 'Tin_PIN'
ELSE ''
END