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.
Solved! Go to Solution.
@SD9126 also make sure in your macro the below option is updated (View-Interface Designer) in the properties
Thanks a lot. It worked. Still couldn't understand what went wrong in my step for batch macro. But anyways, thank you :)
Happy to help : ) @SD9126
If our response helps please don't forget to mark it as solution.
Cheers and have a nice day!