How to remove incremental records after join

[Kinetic_analytics]

Hello:

I have two excel files. One input has to match with another. At the end output records should be matched with the first base file. I have used the Unique tool.  Still, I could see almost double records in the output. How could I manage the records that are equal to data inputs and output?

Thanks

[atcodedog05]

Hi @Kinetic_analytics 

Can you provide some sample input and expected output It will help us get a better understanding of the usecase.

We will be happy to help : )

[Kinetic_analytics]

Hello: 

Please check the attachment file. 

Thanks

[atcodedog05]

Hi @Kinetic_analytics 

Your data is confusing and seems like there is no valid match for the vlookup. You can use find and replace tool it works like excel vlookup and should prevent duplication.

Here is an interactive lesson on it: https://community.alteryx.com/t5/Interactive-Lessons/VLookUps-with-Designer/ta-p/80201

If you can provide data with keys to join on, successful matches, and cases where duplication is happening I will be able to help you.

Hope this helps : )