Adding prefix word and field together

[nwatzlaf]

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

[atcodedog05]

Hi @nwatzlaf ,

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

[jdunkerley79]

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 · Accepted solution]

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.

Let me know if that works for you

Cheers

[nwatzlaf]

This is great. Thanks so much!!

Natalia