Hi,
I have 3 files that I need to join together by Account Number. Each file has different fields that I need. The image attached is the output I'm getting, but I want the joined account numbers to all be on the same line. So it should go something like
Account Number > Input 1 Field 1, 2, 3, etc > Input 2 Field 1,2,3,etc > Input 3 Field 1,2,3,etc. There should not be line breaks like there are below.
Due to the nature of my work I can't provide my specific example as it's all confidential. But basically 3 files, all have the same account numbers, I want them to all join together on one row, not stagger like they are currently doing. What am I doing wrong?
I'm using a Join Multiple tool to bring these files together by account number.
Solved! Go to Solution.
this result of your print I was only able to arrive using the union tool with this configuration
It's a bit cryptic but you can see I have 3 inputs going to a join multiple. Apologies I can't screenshot file names or outputs names either because that has client info. But that's what my workflow is. 3 inputs, join multiple based on patient account number. Ignore the fact that it says missing fields, I disconnected the tool last week and tried a union AFTER making the initial post to see if a union would work better.
Well, the keys not being equal or not having relationships between input _1, input_2 and input _3 gives the result you are having in your join multiple tool
see the print
Check if the keys are related. There is something wrong with the keys......
As you can't send real data or similar I'm trying to simulate some data.
These are the keys to relationships
There are no relationships between the 3 tables
The result that you are having in the join multiple tool is due to the fact that there is no correspondence, for example, the number 10 in the 3 tables, so this is empty and according to the increasing order of the numbers in each table, the tool will fit the order of the number in each input table .
When it exists in the 3 inputs the result is this
