How to join multiple input files?

[johny9887]

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

[Luke_C]

Hi @johny9887 

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

1. The first join joins on location number
2. The second join joins on location number and reporting date

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

[johny9887]

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