Date Macro Filter

I created a workflow to review the last 8 days worth of a data set. The filter (below) pulls in 8 days of data and then the rest of the flow checks to see if any changes have happened to the data based on the minimum date available:

[Date] >= ToDate(DateTimeAdd(DateTimeToday(), -8, "days"))

This process works great, but now I need to run the process iteratively for the past couple months, is there anyway to create a macro so that I can pull in chunks of 8 days worth of data at a time. The rest of the flow will be easy to modify, i'm just not sure how to setup a macro to pull in 8 days of data at a time based on a start date, say Jan 1 2020.

Datasets

Macros

Date Time

Optimization

Accepted answers

Jonathan-Sherman

Sounds as though you need to convert it to a batch macro. You'll need to add a control parameter, connect that up to your filter (to the thunderbolt icon) will create an action tool, and just replace the DateTimeToday() string. The control parameter will create another input anchor on your macro. Use this to feed in a list (text input) of dates you wish to filter for and your macro will run once for each line in your text input tool.

https://help.alteryx.com/2018.2/BatchMacro.htm

Jonathan-Sherman

Hi @AlteryxUserFL,

Of course!

I've attached an example workflow.

So i started with an example input:

The macro itself looks like the below, and in essence is filtering for where the date is greater than or equal to a certain date (defined by the control parameter) and also adding in a new column with the date defined by the control parameter so we know which run the record came from.

The output of running this batch macro with two values in the control parameter input of 2020-01-05 and 2020-01-02 would be:

If this solves your issue please mark the answer as correct, if not let me know! I've attached my workflow for you to download if needed.

Regards,

Jonathan

20200218 - BatchFilterPerDateWorkflow.yxzp

All comments

Jonathan-Sherman

https://help.alteryx.com/2018.2/BatchMacro.htm

AlteryxUserFL

Thank you for the info, I read the link and converted the flow to a batch macro. Do you have any examples of how I could setup a batch macro to pull in 8 days worth of data at a time.

Quick Links

This months top contributors

mceleavey 382

LanisC 335

hhaigh1 280

erich_shiino 280

FláviaB 262