Trouble with joining multiple inputs

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.

Datasets

Help

Join

Data Investigation

Accepted answers

geraldo

@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

All comments

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

multiplejoin.yxmd

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703