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 |
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!
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