Adding prefix word and field together

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

Transformation

Accepted answers

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

All comments

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

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

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

This is great. Thanks so much!!

Natalia

Quick Links

Tags

This months top contributors

atcodedog05 19458

Qiu 15866

MarqueeCrew 13708

apathetichell 13703