Announcement | We'll be doing maintenance between 2-3 hours, which may impact your experience. Thanks for your patience as we work on improving the community!
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
