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
Are you able to upload the Alteryx workflow you are using to join the data?
@akin_sony - See attached. Is this what you need? If this helps, please mark as solution. Thanks!
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.