SOLVED
group and concatenate
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
Johmz
8 - Asteroid
‎02-21-2024
11:00 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Need help to group data and concatenate if different input
Input
STATE | PRODUCT | SORT |
Florida | Apple | Box |
Florida | Orange | Bag |
Ohio | Apple | Box |
Ohio | Apple | Bag |
Kansas | Apple | Bag |
Kansas | Orange | Bag |
Nevada | Apple | Box |
Nevada | Orange |
Output
STATE | PRODUCT | SORT |
Florida | Apple/Orange | Box/Bag |
Ohio | Apple | Box/Bag |
Kansas | Apple/Orange | Bag |
Nevada | Apple/Orange | Box |
Solved! Go to Solution.
5 REPLIES 5
apathetichell
19 - Altair
‎02-21-2024
11:02 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
summarize tool. group by state. concatenate product. concatenate sort. / is your delimiter.
although in your case - it might make more sense to split this up into two streams. do two summarizes in each (group by/group by and then group by/concatenate) (to get each unique sub entry of sort/product) - and then rejoin on state after the concat. you can filter out blank fields if you want prior to concatenating.
binuacs
21 - Polaris
‎02-21-2024
11:09 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
‎02-21-2024
11:24 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks apathetichell. its a big help.
‎02-21-2024
11:25 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks binuacs. its a big help.
HomesickSurfer
12 - Quasar
‎02-21-2024
01:10 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
