Appending multiple excel files

[sriniprad08]

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

[atcodedog05]

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 🙂

[sriniprad08]

Thank you so much . Really helpful.

[atcodedog05]

Happy to help 🙂 @sriniprad08 

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

Cheers and Happy Analyzing 😀

[sriniprad08]

Sorry i couldnt find the option for marking as a solution

[atcodedog05]

Oh ok

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

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

Anyways Happy to help 🙂

[StephV]

Hi @sriniprad08,

Thank you for your question to the Community!

I moved your post to the Designer Discussions forum there you can ask anything technical about Designer. 

If the @atcodedog05's post helped you please mark it as solution here. 

Cheers,