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