In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests after December 31, 2025. Set up your security questions now so you can recover your account anytime, just log out and back in to get started. Learn more here
Start Free Trial

Alteryx Server Discussions

Find answers, ask questions, and share expertise about Alteryx Server.

Find duplicates more then one Field

Doriandel
6 - Meteoroid

Hi all,

 

I would like to find the duplicate I have in an excel sheet, but for more than a field at a time.

 

To be clear, I have rows for each different transactions, and I'd like to find the duplicates. So the tool should look for the name of the client, the amount and the VAT code.

 

Because, if I only look for the name or the amount, I will find a lot of "duplicates".

 

If anyone has an idea to solve my problem don't hesitate to let me know.

 

 

Thanks in advance

3 REPLIES 3
ponraj
13 - Pulsar

Possible to share sample data and results?

Doriandel
6 - Meteoroid

These are the titles of the column I have. And so I'd like to be able to check that there isn't any duplicate rows in my sheet. But if I only check one column, that won't work, as there are more than one transaction by suppliers for example.

ponraj
13 - Pulsar

Try using unique tool