How to move data from one column to another

[ericbob93]

Hey all, 

I am trying to create an Alteryx expression that will recognize the Transaction Type and will move the total cost data accordingly. In this case, I am trying to move all AMCR Transportation Total Costs to the Transportation column.

I am getting an error on the formula I have created below. Can someone point me in the right direction? 

 IF [Transaction Type] = "AMCR Transportation" THEN [Transport ] ELSE Null() ENDIF

[ivoller · Accepted solution]

Hi,

I don't see a Transport Column. If you're applying this formula to the Transportation column then it looks like what you need is

IF [Transaction Type] = "AMCR Transportation" THEN [Total Cost] ELSE Null() ENDIF

Let me know if I am misunderstanding the question

[ericbob93]

Thank you so much! That Column was supposed to be transport,  but your formula worked!