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

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

Process_data.yxzp