Trouble with joining multiple inputs

[WishIKnewHowToCode]

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.

[Yoshiro_Fujimori]

@WishIKnewHowToCode 

Without data or workflow which is causing an issue, it is difficult to guest what's causing the issue.

(That said, at a first glance, your output looks like the output of Union tool, rather than Join Multiple tool.)

Can you share the following screenshots?

• workflow where you see the issue
• configuration of Join Multiple tool

[geraldo]

@WishIKnewHowToCode 

this result of your print I was only able to arrive using the union tool with this configuration

[WishIKnewHowToCode]

I am absolutely not using a union tool to arrive at that result. I promise it's a join multiple. Again, I cannot share my actual files, they are patient data files. I am sure no one wants me putting their private information out there. I can only provide dummy info

[WishIKnewHowToCode]

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.

[geraldo]

@WishIKnewHowToCode 

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

[WishIKnewHowToCode]

Can you elaborate on what "keys" are?

[geraldo · Accepted solution]

@WishIKnewHowToCode 

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

[WishIKnewHowToCode]

Yep, you are correct. I was not filtering my output to find the rows that had matches essentially. I was under the impression that the join would eliminate data that did not match based on the account numbers. So basically I misread my output. Thank you for helping me come to this realization!

[geraldo]

@WishIKnewHowToCode 

If you configure this option, it will only allow records that match all inputs