Concatenate columns and also retain other columns in the out put data

[KamalChoudhary]

Hi 

Is it  possible to concatenate  Headers 3,4,5,6,7,..... dynamic number of headers count changes every time based on file input data.

while doing concatenatination keep header 1 and 2 in the output data as shown in the below example 

Input Data 

Header 1	Header 2	Header 3	Header 4	Header 5
.5SP07	954	VPS	NXP	NXP
.HKL5321	586	VTS	HKP	HKP
.5697P	86P	HKP	VPS	MSP
.55897	LEFT	NXP	VTS	VPS
.MXP01	RIGHT	MSP	MSP	VTS

Output Data

Header 1	Header 2	concatenate Headers	Header 3	Header 4	Header 5
.5SP07	954	VPS,NXP,NXP	VPS	NXP	NXP
.HKL5321	586	VTS,HKP,HKP	VTS	HKP	HKP
.5697P	86P	HKP,VPS,MSP	HKP	VPS	MSP
.55897	LEFT	NXP,VTS,VPS	NXP	VTS	VPS
.MXP01	RIGHT	MSP,MSP,VTS	MSP	MSP	VTS

[jrgo · Accepted solution]

Hi @KamalChoudhary 

Using the transpose tool to pivot the columns plus keeping the "Dynamic or Unknown Columns" option checked, the summarize tool will concatenate the values grouped on the recordID field added (can use your own data if it has a unique row ID field). 

Hope this helps!

Jimmy

[messi007]

@KamalChoudhary,

Please see below

Attached the workflow.

Hope this helps!

Regards

[atcodedog05]

Hi @KamalChoudhary 

I have replied for you question on this post 🙂

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Hi-I-have-a-problem-separating-data-st...

Hope this helps : )

[binay2448]

May be this can help you....