If you have been using Alteryx for a while and have used the Join tool, I am quite confident that you have come across this scenario a few times.

When you join two data sets using specific fields that have identical field names, you will have duplicate values from the right-hand input and Alteryx will add a prefix “Right_” to the duplicate variables. In most cases, the best practice is to drop these duplicates fields.

It is quite simple when you only have one or two duplicate fields as you could simply deselect them. However, when dealing with larger and more complex data sets, and the number of joined fields increase, it is quite tedious to deselect each field one by one, and there is also chance that you may miss one of them. There is an option in Alteryx Join tool configuration to allow you to deselect multiple duplicate fields at once. 

You can deselect all the duplicated fields at once by clicking Options -> Deselect Duplicate Fields:

That’s it. This option will enable you to remove multiple duplicate fields from the right input all at once. I find it much more convenient and reduce chance of missing any of the duplicate fields, which will be confusing later on. I hope you will find this tip as helpful as I did. Thanks for reading.

See you in my next blog!

 

Thao Phuong Tran
Author: Thao Phuong Tran

Thao is an experienced 3PL Warehouse Administrator and Retail Assistant Manager. Driven by a passion for data analytics and information technology, she takes pride in providing the best analysis to help businesses in making data driven decisions and tackling their issues. As a Data Analyst Consultant at The Data School, her goals include learning from the best people in the data industry and up skilling herself with relevant and powerful tools like Tableau, Alteryx, Power BI, etc. She adores applying process automation to improve her productivity and efficiency at work. When Thao is not keeping busy with data, you can find her enjoying collecting Pandora charms and baking chocolate mint cookies. She also loves dining out and a meal that never fails her is spicy Pad Thai paired with a Vodka Sunrise!