Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Hi folks,
I have a need to generate missing rows. If there are two "Total People", it should search in column "Person" for numbers 1 and 2.
If any numbers <= to the total number in "Total People" are missing, it should generate those rows.

So in my first image where it is wrong- there are 2 "Total People" but only records for person #2. The correct result would look like the second image where "Person" #1 and "Person" # 2 now exist.

The number of "Total People" may vary. Sometimes all are accounted for. Other times I may have 10 total people but only "Person" #3 and Person #5 exist in the data.

Is there a dynamic way to determine and fill in the missing records from "Person"?

Thanks you,
S-Bon