ALTERYX INSPIRE | Join us this May for for a multi-day virtual analytics + data science experience like no other! Register Now

Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

Batch - MACRO - Post recreated

suby
8 - Asteroid

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.

 

The ultimate goal is to filter the Required sheets in the Main workflow  is there a way to apply the filters for specific sheet in the main workflow before combining all the data sets .

 

when i say filters for specific sheet i want to create two streams like below and this has to happen to before combining all the data sets.

suby_0-1620157091726.png

 

 

 

 

fmvizcaino
16 - Nebula
16 - Nebula

Hi @suby ,

 

You can't filter your sheet from your main workflow but you can insert one more control parameter to capture the sheets you want to filter in your first macro.

I know it isn't quite what you described, but this is the only solution I was able to see.

 

Something like this:

MC1:

fmvizcaino_0-1620160473693.png

 

Main:

fmvizcaino_1-1620160605847.png

 

Workflows attached as well.

Best,

Fernando Vizcaino

 

 

suby
8 - Asteroid

Hi

 

Thanks for your solution.

 

Yes you're right Ultimately 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.

 

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.

 

 

Labels