Combine all columns in a row with pipe delimiter

[ramanm43]

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:

Code	directory	sic	sic_desc	seg
gb14627	Accountants	45682	Business	n
gb37280	Editorial	47895	Business	n
gb47289	Beauty	14498	Personal	y
gb25390	Editorial	56487	Business	n

Required Output:

gb14627|Accountants|45682|Business|n

gb37280|Editorial|47895|Business|n

gb47289Beauty14498Personaly

gb25390Editorial56487Businessn

Thanks

[grazitti_sapna · Accepted solution]

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.