In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Removing data based on most recent run

nickrosen28
7 - Meteor

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!

3 REPLIES 3
binuacs
21 - Polaris

@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.

image.png

nickrosen28
7 - Meteor

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
7 - Meteor

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

Thanks,

CH

Labels
Top Solution Authors