Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

How to move data from one column to another

ericbob93
5 - Atom

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

2 REPLIES 2
ivoller
12 - 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

 

 

ericbob93
5 - Atom

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

Labels