How to join data and remove duplicate values due to duplicate matches?

[akin_sony]

I'm joining on 

T_Artist = master_artist

T_RELEASE_NAME = product_name

DATE = report_date

Everything before column L is one table and everything after is another table

[olly_jones_98]

Are you able to upload the Alteryx workflow you are using to join the data?

[griffinwelsh]

You can use a dynamic select tool after the join and deselect anything with the right_ prefix out of the join tool.

[Bren_Spill]

@akin_sony - See attached. Is this what you need? If this helps, please mark as solution. Thanks!

[jdminton]

You can use @Bren_Spill's solution above to remove duplicates, however, that will not remove anything in your case since your records are unique when including all fields.

Based on your Excel file, it appears that you may be looking at advertising campaigns. Those are unique. If you would like to focus in on specific campaigns, filter the data prior to that for the specific campaign you are wanting to see. If you want to see just one artist and aren't concerned about the specific campaign, use a summarize tool to group by T_ARTIST, T_RELEASE, and DATE before the join. You can group by on other fields as well, but if you use fields that are not exactly the same for all records in your key (artist, release, date) you will end up getting the same song from the right data set multiple times. You can concatenate those other fields if you'd like that data with the results but not duplicated.