Concatenate w/out duplicate values
- 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 want to concatenate a field but prefer not to have duplicate values. Grouping by [Date] and concatenating [Workspace]
e.g.
Employee ID | Employee Name | Date | Number (unit) | Rec. sales order | Location | Workspace |
1114 | John Smith | 1/2/2023 | 8 | US-NY-YK | ||
1114 | John Smith | 1/3/2023 | 2 | 512713 | US-NY-YK | Client Office |
1114 | John Smith | 1/3/2023 | 8 | 377671 | US-NY-YK | Client Office |
Desire output:
1/3/2023 | Client Office. (Currently getting, 1/3/2023 | Client Office, Client Office.
e.g.
Employee ID | Employee Name | Date | Number (unit) | Rec. sales order | Location | Workspace |
1114 | John Smith | 1/25/2023 | 2 | 377655 | US-NY-YK | Client Office |
1114 | John Smith | 1/25/2023 | 7 | 377671 | US-NY-YK | Client Office |
1114 | John Smith | 1/25/2023 | 1 | 576465 | US-NY-YK | Work from Home/Remote |
Desire output:
1/25/2023 | Client Office, Work from Home.
Current output:
1/25/2023 | Client Office, Client Office, Work from Home.
please HELP. Thank you
Solved! Go to Solution.
- Labels:
- Workflow
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@coryanthony - change the Action for workspace to Group By
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@Bren_Spill - Since i still need to concatenate the [Workspace], that workflow will not work. I don't want to group by workspace. I need one row per date.
Employee ID | Employee Name | Date | Number (unit) | Rec. sales order | Location | Workspace |
1114 | John Smith | 1/25/2023 | 2 | 377655 | US-NY-YK | Client Office |
1114 | John Smith | 1/25/2023 | 7 | 377671 | US-NY-YK | Client Office |
1114 | John Smith | 1/25/2023 | 1 | 576465 | US-NY-YK | Work from Home/Remote |
Desire output:
1/25/2023 | Client Office, Work from Home/Remote.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@coryanthony - apologies. I misunderstood the request. Try the attached
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@Bren_Spill You're awesome! Thank you so much. I see the logic now.
![](/skins/images/A7612391DEAF4EF69C140133EA533832/responsive_peak/images/icon_anonymous_message.png)