SOLVED
Loop in dataset (string)
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
svergtanya
7 - Meteor
‎11-10-2020
03:17 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi,
I have a string, that has agregaret statuses. How I can go through a dataset and identify all statuses codes, that I missing per every unique ID (column 'Missing')? Example is below
Example:
ID | Statuses | Missing |
123456789 | ABC, CPA, KLP, DRO | FKSL, KFS, ARS |
987654321 | ABC, CPA, KLP, DRO, PRT, FKSL, KFS | ARS |
Solved! Go to Solution.
3 REPLIES 3
PhilipMannering
16 - Nebula
‎11-10-2020
03:21 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
You can have the complete list of statuses in a Text Input (or other file) and join on Statuses (once this has been split to rows using the Split to Columns Tool). All the statuses that don't Inner Join are missing. Then Summarize (and use concatenate) to list all these MIssing values in a single cell.
PhilipMannering
16 - Nebula
‎11-10-2020
03:28 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
‎11-10-2020
09:08 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you for the recommendation. It worked perfectly!