Batch Macros

[Hi2023]

Help!

I have several excel files that have multiple tabs that I need to join but when I did dynamic input to pull all the tabs and excel files together, it said fields are not the same will be skipped. So, I read that I need to do a Batch Macro, I saw a few vids but need a little more help if this is the correct way.

8 excel files -multiple tabs within those excel sheets -the columns and tabs same. 

thanks

[Felipe_Ribeir0]

Hi @Hi2023 

Take a look at the attached workflow. It has an example of how to use it.

If you want to understand it better, you can read this great topic:

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

[Hi2023]

So out of my directory nothing is populating. 

I have the Directory pointing to my File location.

File Specification should show ".xlsx" for excel files

I left Fullpath V_WString for field

When I opened the macro - What do I input for control parameter?

thanks

[Felipe_Ribeir0]

@Hi2023 

Can you share 2 excel files just with the header and dummy data? So i can configure for you and send it back.

You do not need to change anything inside of the macro, it is already configured for .xlsx files.

[Hi2023]

It is 8 files that I need to join with 6 tabs within each excel report --well I only need the first 3 tabs within each report to be joined.

thanks

[Felipe_Ribeir0]

@Hi2023 

Try the attached workflow. I added some explanations on each tool.

[Hi2023]

Wow thank you so much! 

[Felipe_Ribeir0]

@Hi2023 dont worry about the macro (this macro is already configured to input any xlsx files), just about the main workflow and about the parameters that you are passing to the macro. When you point the directory tool to the folder that contain the xlsx files and run the workflow it is doing what is expected?

Main workflow:

[Hi2023]

Yes, but  i dont see the 3 tabs from each excel-it only has 1 tab inside th eoutput file?

[Hi2023]

thanks