Removing data based on most recent run

[nickrosen28]

Hi all,

I have a question that will be instrumental to the final step of my workflow.

I am running my workflow for 1 month in isolation, but will append results to the bottom of the workflow with all previous months data. But I am unsure how to deal with this if I am re-running the workflow for a month that I already have data for, I want to take the most recent run for that specific month.

In the attached file I would want to remove the data in red and keep the data in yellow because it was run after.

Any advice would be greatly appreciated!

[binuacs]

@nickrosen28For each run, add a variable that increments with every execution. You can initialize this variable to 1 during the first run and increase it by 1 in each subsequent run. This way, to retrieve the latest data, you can simply use the maximum value of this variable.

[nickrosen28]

Great idea! How would I create those values but just for each month?

Since in my example i want to keep all the OCT stuff, but only need the most recent November?

[Colman_Hendershot · Accepted solution]

@nickrosen28 I have attached an alternative solution. Let me know if it works as intended. 

Thanks,

CH