Combine/Consolidate excels

[AS]

Hi Experts,

I have 12 excel heavy  files around 116MB each and I want to consolidate them and perform some common function filter and cleansing function. so please suggest me something how could I consolidate all those files and perform tasks.

I tried so many examples from community to solve my problem but nothing worked. please help!

[atcodedog05 · Accepted solution]

Hi @AS 

Have you tried the methods in this article.

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/The-Ultimate-Input-Data-Flowchart/t...

Hope this helps : )

[AS]

Hi @atcodedog05 

NO I have not tried but I'm in hurry right now. I need to complete a task and could not find any solution if you have any workflow available that would be really helpful. I'll surly look in to that article later.

[atcodedog05]

Hi @AS 

There is an example workflow attached at the bottom of the article you can use that.