MACRO - Any Suggestions?

what I'm trying to achieve is I have two excel files ( Two months Data) with two tabs with different schema and I want to combine all these into one single Dataset which can be done by creating the Nested macro mentioned in the post below by Andrew.

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Read-in-Multiple-Excel-Files-with-Multiple-Tabs-that-have/tac-p/330400#M3555

The solution By Andrewl combines the Data set when we run the workflow based on different schema with multiple tabs and Multiple sheets.

What I'm looking for is still I want to combine two files with different schema and I should be able to filter for specific worksheet in my main workflow and then do combine the data set on my main workflow say.

I'll leave this open for the community geeks to see if any one can provide a solution.

Batch Macro

Accepted answers

mceleavey

Hi @suby ,

I have two macros that do this for you. The first reads in the sheet names and appends to the filename. The second reads each file in dynamically and creates a single file of all inputs.

I've attached the macros and and example workflow.

I hope this helps,

Import Multiple Schema Flat Files.yxmc

Dynamic Multi File Sheet Names.yxmc

Multi Sheet Import Example.yxmd

All comments

mceleavey

Hi @suby ,

I have two macros that do this for you. The first reads in the sheet names and appends to the filename. The second reads each file in dynamically and creates a single file of all inputs.

I've attached the macros and and example workflow.

I hope this helps,

Import Multiple Schema Flat Files.yxmc

Dynamic Multi File Sheet Names.yxmc

Multi Sheet Import Example.yxmd

suby

Hello,

Thanks for your time.

Could you please advise or plug in my sample Data set to your macro please struggling a bit to understand on what it does.

File1_28-02-2021.xlsx

File2_31-03-2021.xlsx

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703