Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions?
Ask here!
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
