How to join files based on a shared data point

[Mark_Sneed]

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

TV

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

Output:

File name: XYZ

Food

Sports

TV

[alexnajm · Accepted solution]

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!

[dreldrel]

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