Dev Space

Customize & extend the power of Alteryx. SDKs, APIs, custom tools, and more!
SOLVED

Combine/Consolidate excels

AS
8 - Asteroid

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!

3 REPLIES 3
atcodedog05
20 - Arcturus

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
8 - Asteroid

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
20 - Arcturus

Hi @AS 

 

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