We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

How to join files based on a shared data point

Mark_Sneed
5 - Atom

I have 3 files containing the following info:

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

 

File 1 : 

File name: XYZFood

 

File 2:

File name: XYZSports

 

File 3:

File name: XYZTV

 

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

 

Output:

File name: XYZFoodSportsTV
2 REPLIES 2
alexnajm
18 - Pollux
18 - Pollux

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

Screenshot 2025-09-11 110636.png

 

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

dreldrel
8 - Asteroid

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 

Labels
Top Solution Authors