Pass Dates to filter from Dates column & Save output

[36892362]

Hi Team,

Question 1: I have set of dates which i want to pass on to filter tool one by one, i.e first i pass a date 31/03//2022 then workflow runs . Once completed then pass on the next date run the workflow.

Question 2  Each time when the workflow runs with new date , need to save the output  which i would like to consilidate and create further flow from it.

[Felipe_Ribeir0]

Hi @36892362 

To pass dates row by row, you gonna need a macro like this one. For each iteraction the date is filtered inside the macro and whatever you put inside of the macro will happen for each date. After all iteractions, the result is consolidated and you can save as you wish.

INPUT

Workflow

MACRO

OUTPUT

[RogerS]

If you want to just crate outputs for each date you can use the date to create unique file names for each date.  the bottom of the output tool you will see a check box to use a field (date for you) and add it to the file name.  This will create a unique file for each date.

[36892362]

Hi Roger,

Appreciate your reply, i dont want the output as files but within the workflow keep the output for each date and then consolidate it. 

[36892362]

Hi @Felipe_Ribeir0 

I will try this as suggested in my workflow and confirm, appreciate your response.

[36892362]

Hi Felipe,

Thank you for the response, due to our YE priorities. Could not test the below, soon will test it.

Appreciate your help