Writing a Loop in Tableau that replaces NULL values for Pension values
I want to replace NULL values in the "JOB" column with "Retired" in Tableau, if that particular person has a "pension" in the "INCOME" column.
IF CONTAINS([JOB], "NULL")= CONTAINS([INCOME], "PENSION")
I have to continue with a "THEN" statement but I can't seem to get the syntax correct in the first place.
Please help me.