Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
Start Free Trial

Alteryx Designer Desktop Discussions

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

Adding a column populated by an IF statement.

SflynnAZBlue
5 - Atom

I have created a workflow with most of the data that I need but now I need to add a new column that will populate an account number based on the location # column.  With the basic example below I need to add a new column that will be populated by an if statement.  If location = 1 then account number 12345.  I am missing how to create that new column so I can use a formula tool to populate it. Any help would be greatly appreciated.

 

Location  City           State  Zip code

1              Chandler  AZ      85225

2              Mesa        AZ      85234

3              Gilbert      AZ      85241

 

 

3 REPLIES 3
Felipe_Ribeir0
16 - Nebula

Hi @SflynnAZBlue 

 

You can create this new column with the formula tool, like this:

Felipe_Ribeir0_1-1664387239772.png

 

Felipe_Ribeir0_0-1664387132312.png

 

If the provided answer helped you to solve the problem/was correct, please accept it as a solution :)

 

Thanks.

 

SflynnAZBlue
5 - Atom

That work great.  Thank you!

Felipe_Ribeir0
16 - Nebula

No problem :)

 

 

If the provided answer helped you to solve the problem/was correct, please accept it as a solution :)

 

Thanks.

 

Labels
Top Solution Authors