Fetching/Setting Data dynamically

Hi Team,

I want to set a column value of one record with another column value.

Say, I have a Column called "User" having value "abc@domain.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.

Thanks,

Ankit