Automating Filter Tool having Date Range

[Sg2468_80]

I have a very long workflow and a filter tool present in that workflow has a condition like this 

[Date_0] >= "2022-01-01" AND [Date_0] <= "2023-03-31" 

Currently i am executing the workflow 17 to 18 times after editing filter tool  as per the conditions given belwo

I want to automate this workflow so that the conditions given below are present in excel and workflow runs automatically 17 to 18 times

when clicked once   

[[Date_0] >= "2022-01-01" AND [Date_0] <= "2022-12-31"
[Date_0] >= "2022-01-01" AND [Date_0] <= "2022-07-31"
[Date_0] >= "2022-01-01" AND [Date_0] <= "2022-08-31"
[Date_0] >= "2023-01-01" AND [Date_0] <= "2023-03-31"
[Date_0] >= "2023-04-01" AND [Date_0] <= "2023-06-30"
[Date_0] >= "2023-01-01" AND [Date_0] <= "2023-01-31" 
[Date_0] >= "2023-02-01" AND [Date_0] <= "2023-02-28" 
[Date_0] >= "2023-03-01" AND [Date_0] <= "2023-03-31" 
[Date_0] >= "2023-04-01" AND [Date_0] <= "2023-04-30" 
[Date_0] >= "2023-04-01" AND [Date_0] <= "2023-04-30" 
[Date_0] >= "2023-05-01" AND [Date_0] <= "2023-05-31" 
[Date_0] >= "2023-06-01" AND [Date_0] <= "2023-06-30" 
[Date_0] >= "2023-07-01" AND [Date_0] <= "2023-07-31" 
[Date_0] >= "2023-08-01" AND [Date_0] <= "2023-08-31" 
[Date_0] >= "2023-09-01" AND [Date_0] <= "2023-09-30" 
[Date_0] >= "2023-10-01" AND [Date_0] <= "2023-10-31" 
[Date_0] >= "2023-11-01" AND [Date_0] <= "2023-11-30" 
[Date_0] >= "2023-04-01" AND [Date_0] <= "2023-12-31" 

[alexnajm]

Sounds like you need a batch macro! It can take a list of these dates and run the workflow based on the number of records you feed into it. 

Having the workflow would be beneficial so we can help further!

[Sg2468_80]

Can't attach the complete workflow attaching the screen shot of filter that need to be updated every time when i run workflow. 

Fills_0 or Date_0 column is created dynamically from cross tab tool.  using this filter, we get different number of records, but they can only be identified when we apply that filter. 

[alexnajm]

I am sorry, but I can't really help further without a workflow or something to work off of - otherwise I am just guessing in building the macro.

What I can do is pass on some resources to help - good luck!

• Getting Started with Batch Macros (alteryx.com)
• Why use a batch macro - Alteryx Community
• Macro Maynia: Macros...a piece of cake! - Alteryx Community

[Sg2468_80]

Attaching the workflow and sample records

[Sg2468_80]

this workflow i have to execute 17 to 18 times after changing the date condition. So I want 17 to 18 filter condition in excel. And worflow iterates for all filter conditions and produce output.

[binuacs]

@Sg2468_80 What are you trying to achieve here? If you can provide some more information i think there is a better way of doing this

[alexnajm]

I was able to build a batch macro that works to run the different date filters one after the other. It looks like the workflow is cut off compared to your real workflow, so I don't know your end product, but this works!