SOLVED
Concatenate columns and also retain other columns in the out put data
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
KamalChoudhary
7 - Meteor
‎08-19-2021
01:22 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
Labels:
- Labels:
- Join
- Preparation
- Reporting
- Transformation
4 REPLIES 4
jrgo
14 - Magnetar
‎08-19-2021
02:02 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
15 - Aurora
‎08-20-2021
01:14 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
22 - Nova
‎08-20-2021
01:32 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I have replied for you question on this post 🙂
Hope this helps : )
binay2448
11 - Bolide
‎08-20-2021
02:56 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
