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.
Hello all!
I have a spreadsheet with multiple lines with the same invoice number. Is there a way that if an invoice number has a "1" then all invoice numbers that are duplicates of it are removed as well? So like below, all of the same invoice numbers and there is a "1" on a line. I would want to remove all of those lines. Kind of hard to explain!
Thank you!
The easiest way is to add a filter and filter for Normal Payment = 1.
A more complicated way would be to
- use the summarize tool
- group by the Invoice Number
- Find the minimum Normal Payment Number
- Join the original data and the summarized data together on Invoice Number and Normal Payment
