Aggregate multiple values into one
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello,
I have a workflow where I need to create a new field that combines the values from an existing field (Research ID) where the group by is Company ID. I've attached the starting point of this workflow and an excel file to show the desired output - with column C being the column I'm trying to create. For example, there are two records where Company ID = 8007120. The first record has Research ID = 1234 and the 2nd = 5555. I'm trying to get these two values grouped together with a "/" divider as displayed in the attached xls. Any ideas on how to do this?
Solved! Go to Solution.
- Labels:
- Data Investigation
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Add a summaries tool and then Group by Company id and Concatenate on basis of Reserch ID and add delimiter as "/"
this will work.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you very much for the help. That worked great!
