Transform

I have two columns that might have the same values for some rows. How can I use string compare in a custom formula for two columns.

Example:

case column1 == column2

when True then "No Transfers"

else "Transfers"

end

8 answers

Jul 3, 4:23 AM

In case anyone asks the same question -

This worked for me,

if ( columnA_name = columnB_name, 'Yes', 'No' )

*Output type = Text

This did NOT work,

case

when columnA_name == columnB_name,

then 'Yes',

when columnA_name != columnB_name,

then 'No',

else null

end

*Output type = Text

Add a comment

0/9000

Einstein Analytics