Combine all columns in a row with pipe delimiter

Question

Hi All,

New user to Alteryx and have been tasked to update an existing flow. I have searched the forum for an existing topic to help with my issue but was unable to find anything relevant for my issue, would be grateful if someone could point me in the right direction.

I have a flow which produces a result but I need to update this so the output file is as below:

Current output:

Codedirectorysicsic_descseggb14627Accountants45682Businessngb37280Editorial47895Businessngb47289Beauty14498Personalygb25390Editorial56487Businessn

Required Output:

gb14627|Accountants|45682|Business|ngb37280|Editorial|47895|Business|ngb47289Beauty14498Personalygb25390Editorial56487Businessn

Thanks

grazitti_sapna · Accepted Answer

Hi @ramanm43 , you can do it using a select tool and formula tool. I hope it helps and mark this post as solution if it solves your purpose.

Thanks.

1) Change all the data types into string because concatination works only in case of string.

2) Apply formula tool with the following syntax to concatinate with a pipe delimiter

[Code]+"|"+[directory]+"|"+[sic]+"|"+[sic_desc]+"|"+[seg]

3)Output

4) If you want just the Concatinated field as output you can add a select tool and choose only the last field.