Custom Column

[Daven]

Hi,

I want to create a custom column under transform data using below logic. How do I do it?

IF column A = 1 and column B =1 then output "Same"

IF column A = 1 and Column B = 0 then outout "B"

IF column A = 0 and Columb B = 1 ten output "A"

Thanks,

Daven

[Samarth_18 · Accepted solution]

Hi @Daven ,

Try this:-

IF column A = 1 and column B =1 then  "Same"
else
IF column A = 1 and Column B = 0 then  "B"
else
IF column A = 0 and Columb B = 1 then "A"
else " "

Thanks,

Samarth