How to join multiple input files?

Question

Hi,

I have tried using the Join Multiple tool to join the 3 sheets attached below, while i can join 2, whenever i try to join the third one (KPI11 sheet), it doesnt work as intended.

What i want is the following:

- The LocationControlSheet contains the location specific info and has LocationNumber column

- Join the KPI1 Sheet: which contains the LocationNumber column and Date column and the respective KPI information. By doing this, I want the LocationControlSheet info to be replicated for each Dates in KPI1Sheet and add the KPI columns into the joined sheet

- Join KPI11 Sheet: Same as above where I want the KPI columns to be appended into the joined sheet

The current Join Workflow sheet's multiple join shows exactly what i want, but when i join the KPI11 sheet it throws me errors, is there a way to solve this?

Thank you

Join workflow.yxmd

KPI1 Sheet.xlsx

KPI11 Sheet.xlsx

LocationControlSheet.xlsx

johny9887 · Answer

ah ok, the reason why i thought of using multiple join is because although i have only 3 files in this currently, the actual one has 7 files, so I wanted to see if there was a way to reduce the amount of steps

Thank you

Luke_C · Answer

Hi @johny9887

Very rarely will you want to use the join multiple tool. Use two joins to get the data how you want:

* The first join joins on location number
* The second join joins on location number and reporting date

You were getting the error because you created a cartesian join.

Join workflow.yxmd