Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
The Expert Exam is now live online! Read about the specifics and what it took to bring it to life in the blog by our very own Elizabeth Bonnell!

Appending multiple excel files

Highlighted
7 - Meteor

Hi Team,

 

I have downloaded the data in three separate excel file due to size. Now I have to append all the three excel files and get into one in Alteryx.

 

Any help please?

 

Thanks and Regards,

Srini

Highlighted
15 - Aurora

Hi @sriniprad08 

 

There is 2 ways

 

1st way read all files and union it

https://community.alteryx.com/t5/Interactive-Lessons/Blending-Data-with-Unions/ta-p/76632

 

2nd way read all the files using macro. Refer this link.

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

 

Hope this helps 🙂

Highlighted
7 - Meteor

Thank you so much . Really helpful.

Highlighted
15 - Aurora

Happy to help 🙂 @sriniprad08 

 

If this solved your requirement please mark the post as solution.

 

Cheers and Happy Analyzing 😀

Highlighted
7 - Meteor

Sorry i couldnt find the option for marking as a solution

Highlighted
15 - Aurora

Oh ok

 

it  might be because you posted this in Introduce yourself channel. You need to post the questions in designer discussion channel. 

atcodedog05_0-1602842843400.png

I request the moderator to move the post. You might get option after that.

 

Anyways Happy to help 🙂

Labels