Removing data based on most recent run

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!

AYX File.xlsx

Workflow

Tips and Tricks

Date Time

Common Use Cases

Optimization

Accepted answers

Colman_Hendershot

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

Thanks,

Remove Data Based on Recent Run Solved.yxmd

All comments

binu_acs

@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

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

Thanks,

Remove Data Based on Recent Run Solved.yxmd

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703