community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

How to move data from one column to another

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

 

Alteryx.PNG

Highlighted
Quasar

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

 

 

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

Labels