community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

How to create Macro to count and compare with previous count

Meteoroid

Hi,

 

I am new to macros and i have some data which requires constant checks on number of counts every couple of days. What i wanted to do is count the current data and compare the same with previous count which will be updates regularly. Kind of like a feedback loop, Today's count with become previous count tomorrow. Can i do it with other way or only macro can do it?

 

If macros are to be created, will it be standard macro or batch macro. I a little confused with the interface tools as well. I created a workflow but if i have to take dynamic input from the other workflow, how should i do it? 

 

Any help will be appreciated.

 

Thanks

Highlighted
Bolide

@atamagaii,

 

I do not think you need to create a macro. If I am understanding your question correctly, this should work or at least get you headed in the right direction.(see image below)

Note: You will need to create a .yxdb that is yesterday's count.

 

atamagaii Solution.PNG

 

Really all you need to do is Overwrite Yesterday's Count with Today's Count. Workflow is attached.

 

Hope this helps,

MSalvage

 

 

Labels