I want to set a column value of one record with another column value.
Say, I have a Column called "User" having value "email@example.com" , setting this value for the column called "Email".
I tried using if operator:
if(Operation = "GET", User, "N/A") as Email
I know this is not correct way, but I need a workaround for this.
Any idea is appreciated.
Please sign in to leave a comment.