Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

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