We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun 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