How to apply a process to a dataset by date

[SDJ57]

Hello,

I understand the concept to process a batch macro that will apply different calculations based on the field/calculation combination determined. What I need to do is apply the exact same process to a dataset but by date.

For each date in my dataset, there are 106 records and there is a total of 68 dates. I need a unique value for a subset of the fields by each date. If I apply the process to the entire dataset the values are incorrect.

Thanks in advance!

[Felipe_Ribeir0 · Accepted solution]

Hi @SDJ57 

Please take a look at the attached example. I am using a batch macro to summarize Values by Date one by one (you just need to replace this by your processing part). The secret here is to use a update tool replacing the value of the filter for each iteration.

INPUT

Workflow

MACRO

OUTPUT

[SDJ57]

Hi @Felipe_Ribeir0!

Thank you so much for your quick response! I will work on this now!

[SDJ57]

Hi @Felipe_Ribeir0!

This is the ticket! I will need to make some modifications to my macro so that only 1 record returns per date, but that will be the easy part. 

I initially had an error message to map the control parameter to a field, and fixed that with mapping to the Report Date field. I also needed to remove the quotes around the date in the Action tool's "Replace a specific string" configuration.

Thank you !! =)