Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Appending multiple excel files

sriniprad08
11 - Bolide

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

6 REPLIES 6
atcodedog05
22 - Nova
22 - Nova

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
11 - Bolide

Thank you so much . Really helpful.

atcodedog05
22 - Nova
22 - Nova

Happy to help 🙂 @sriniprad08 

 

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

 

Cheers and Happy Analyzing 😀

sriniprad08
11 - Bolide

Sorry i couldnt find the option for marking as a solution

atcodedog05
22 - Nova
22 - Nova

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 🙂

StephV
Alteryx Alumni (Retired)

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,

 

 

 

Steph Vitale-Havreng
Labels