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

Adding prefix word and field together

nwatzlaf
8 - Asteroid

Hi there,

 

I would like some help on adding text to a new field as a prefix to another field. I want to create a column Fulfillment Facility Name and if a previous column reads "Store" I want to make the new column read "Store # ___", the blank being the store number from another column.

 

Any help on this would be greatly appreciated.

 

Thanks,

Natalia

4 REPLIES 4
atcodedog05
22 - Nova
22 - Nova

Hi @nwatzlaf ,

 

Can you give us some sample data, logic and expected output.

jdunkerley79
ACE Emeritus
ACE Emeritus

You would use a formula tool to do this.

 

If the Store is a number the expression would be something like:

 

'Store #' + ToString([Store])

 

 

If you can provide a sample set of data happy to put a sample workflow together

AngelosPachis
16 - Nebula

Hi @nwatzlaf ,

 

I mocked up some data based on your example. You will have to use a formula tool and an IF statement to get the desired output.

 

Screenshot 2020-10-06 132833.jpg

 

Let me know if that works for you

 

Cheers

nwatzlaf
8 - Asteroid

This is great. Thanks so much!!

 

Natalia

Labels