Duplicates

Question

Hi everyone, after using "join" tool I got this results, I use the tool "unique" to remove duplicates but it doesn't give me what I need. Can someone help on that? :(

I got the results attached but what I need is:

Record ID - Folio

1053         - 395577

1054         - 395578

1055         - 395579

1056         - 395580

1057         - 395581

Captura de pantalla 2022-04-19 162646.png

Captura de pantalla 2022-04-19 162627.png

Captura de pantalla 2022-04-19 162304.png

gabrielvilella · Answer

I don't know what do you expect to get by using a unique tool in this dataset. I used it and selected the Record ID field and I got 51 duplicates. But the real question here is regarding your join. Is your intention to get duplicates after the join? In most cases this is not the ideal situation and can be resolved if you remove duplicates for the key fields before the join for at least one of the two tables that you are joining.

CamilaLuna10 · Answer

Thank you!

Alteryx Problem.xlsx

gabrielvilella · Answer

Hi @CamilaLuna10, please attach the actual input file or paste it here. Images are not the best.