There are many ways to resolve this. The Case statement typically takes 1 variable though. So . ..
1) Create a Calculated variable of the join of [country] & [state]
2) Run the Case on the Calculated Variable & return "america" or [country]
That would be one easy method, depending on your complexity.
But AND operator is not there. Could you provide me a sample case statement for above?
1 of 1 people found this helpful
Just use an IF
IF [COUNTRY] ="USA" AND [STATE] = "NY" THEN 'AMERICA' ELSE [COUNTRY] END
Agreed. It is the more robust solution.