topic Re: How to join files based on a shared data point in Alteryx Designer Desktop Discussions

How to join files based on a shared data point

Mark_Sneed — Thu, 11 Sep 2025 14:43:32 GMT

I have 3 files containing the following info:

please note: the File name is the same on all three files.

File 1 :

File name: XYZ

Food

File 2:

File name: XYZ

Sports

File 3:

File name: XYZ

I want to join all the info so it looks like this:

Output:

File name: XYZ

Food

Sports

Re: How to join files based on a shared data point

alexnajm — Thu, 11 Sep 2025 15:07:00 GMT

Have you tried the Join Multiple tool, joining on File Name? Join Multiple Tool

If there is not a common field to use, I would just use two Append Fields tools back to back!

Re: How to join files based on a shared data point

dreldrel — Sat, 20 Sep 2025 22:06:30 GMT

Multiple join tools might be the best choice. One thing you need to be aware of is that if there are any duplicate keys in one of the data input streams, it will make duplicates on the output as well. You can use a unique tool to remove the duplicated keys. If this helps, please like the comment