Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

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

How to keep the last workflow data on the output

wcamarg3
8 - Asteroid

Hi all,

I hope anyone can support me.

 

I would like to store the previous the average Aging workflow data on my output, but I have no idea how I can do it.

 

Basically what I want is:

- Run and record the last data - OK

- On the last run I also would like to store the  previous data Run. As illustrated on the table below:

 

Last Workflow Run Previous Workflow Run 
ItemAvg AgingItemAvg Aging
X10X9
Y50Y52
Z35Z34
A19A18

 

I will be glad if anyone can 

2 REPLIES 2
Garabujo7
Alteryx
Alteryx

Hi @wcamarg3 ,

 

You may write it into a log file or table.

And append each time you run it.

 

Garabujo7_0-1632930468301.png

 

Does that help?

wcamarg3
8 - Asteroid

Hi @Garabujo7  ! Thanks for the reply. If I do it, then will accumulate data. 

 

I would like to create an additional column for the average aging with only the previous run for average aging on the last run.

Labels
Top Solution Authors