Batch MaCro

[suby]

Hi All,

I am trying to Import two  files

File1_28-02-2021  - With Two Tabs ( REGION and PROD)

File2_31-03-2021  - With Two Tabs ( REGION and PROD)

The only difference between these two files is I have an additional Colum  'REG' In File2_31-03-2021.

I followed the link posted by Andrew  below to recreate the Macro with my two sample file as above and i can successfully combine the Data Set on to one single Data set.

 https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Read-in-Multiple-Excel-Files-with-M...

But is there a way to add a filter on my main workflow only  to filter a specific sheet  which are required for my analysis. I. don't want the filter to be applied in any of my macros.

I have attached the sample files with the two macros and my workflow.

Many thanks

[Qiu · Accepted solution]

@suby 
I believe you are saying that you want the sheet name to be included in the output. 😁

[suby]

Hello Qiu,

Thanks for your  time why on your Output is not bringing the data for for File2_31-03-2021.

On your output its duplicating  the File1_28-02-2021

[suby]

Hi Qiu,

I figured out the Issue thanks for the time and solution and it works thanks.

[suby]

Hi Qiu,

I have one question on the solution workflow.

The solution that you gave was absolutely working which is we get the sheet names in the Output.

The ultimate goal is to filter the Required sheets in the Main workflow which is where your solution works but at the same time say in real world if i have 10 files with two tabs with high number of record volumes then in that case we are combining all the Data sets in the workflow  at the initial stage and then only I can apply the filter for specific sheets to be picked up right which is where your solution helps.

is there a way to apply the filters for specific sheet in the main workflow before combining all the data sets