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.
SOLVED

Append multiple excel files' data in a single file

SD9126
7 - Meteor

Hi everyone, I need one help. I have multiple excel data files in a folder. In each file there are 2 sheets: Sheet1 and Sheet2. I want to append all Sheet2 data in a new excel file and also in the output file I need 1 extra column which shows the source file's name. I tried to do this using Wildcard (*) in Input tool but it returned an error saying files' schema are different and ended up pulling only the 1st file's data from the folder. Also tried using Batch Macro but I guess there's some error I'm doing. Please let me know if there is any solution. Thanks in advance.

13 REPLIES 13
atcodedog05
22 - Nova
22 - Nova

Hi @SD9126 

 

Try this set the path here

 

atcodedog05_0-1644571351338.png

 

Hope this helps : )

 

binuacs
20 - Arcturus

@SD9126 also make sure in your macro the below option is updated (View-Interface Designer) in the properties

 

binuacs_0-1644572646131.png

 

SD9126
7 - Meteor

Thanks a lot. It worked. Still couldn't understand what went wrong in my step for batch macro. But anyways, thank you :)

atcodedog05
22 - Nova
22 - Nova

Happy to help : ) @SD9126 

If our response helps please don't forget to mark it as solution.

Cheers and have a nice day!

Labels