Huge data size - Workflow running for too long

[Abhii2658]

I have 5 excel files that i need to merge and carry out a wide range of workflow functions on them to get the desired result.. The workflows are working perfectly when the input is just one files. But when i give 4-5 files the combinations are excessive. Alteryx runs forever and i was surprised to see the data size in some workflows. 

Is there a way to get things moving faster ?

[Abhii2658]

I have 11 Joins in the workflow. 

[Abhii2658]

Still processing, volume is getting huge now 

[messi007 · Accepted solution]

Hello @Abhii2658,

Please check the keys that you're using on the joins as it looks like you have a Cartesian join.

Make sure that you don't have duplication on the keys that you're using  on each join.

Best regards,

[OllieClarke · Accepted solution]

Hi @Abhii2658 if the workflow works fine with 1 file, but goes wrong with multiple, then it sounds like you need to include the filename as a join clause in all your join tools (and also probably as a group by option in all your summarize/cross-tab tools). You can bring in the filename using option 5 in the Input Data tool: 

Hope that helps,

Ollie