Loop in dataset (string)

[svergtanya]

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

[PhilipMannering]

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 · Accepted solution]

Hi @svergtanya 

See potential solution attached.

[svergtanya]

Thank you for the recommendation. It worked perfectly!