Hello!
New to Alteryx! I created the below formula, but want to add that if the field is null, then "Unknown" but am having issues:
iif(contains([parEthnicity],"Hispanic or Latino/Latina"),"Hispanic or Latino/Latina","Non-Hispanic/Non-Latino/Latina")
Thanks in advance for your help!
Solved! Go to Solution.
if IsNull([parEthnicity]) then 'Data Not Collected'
elseif Contains([parEthnicity], 'Hispanic or Latino/Latina') then 'Hispanic or Latnio/Latina' else 'Non-Hispanic/Non-Latino/Latina' endif