Check status in multiple rows for related ID

Question

I am looking to confirm if all tasks have been completed for a specific ID.

I am struggling to achieve this in Alteryx and am hoping you can help using the attached data source as an example.

My desired output is to have one row for each ID simply stating 'Completed' or 'Incomplete'.

Check status in multiple rows for related ID.xlsx

LukeM · Accepted Answer

Hi @adamhill3

See attached for solution.

1. Create flag so Complete = 1

2. Summarize for total and number complete for each ID

3. Create new column for where total = complete

Hope this helps. Let me know if you have any more questions, and flag this as solved so others can find it.

Luke