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 |
Solved! Go to Solution.
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
I have replied for you question on this post 🙂
Hope this helps : )