Huge data size - Workflow running for too long

Question

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 ?

messi007 · Accepted Answer

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 Answer

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