Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

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

Iterative Macro Not Utilizing All Data

Wcasey113
5 - Atom

Hello all,

 

First time posting and first time trying to utilize/understand an iteration macro. I am attempting to utilize the FIFO Stock Aging macro kindly provided by T_Willins previously in the community forums.

 

The macro works until... it doesn't. My example scenario.

 

Wcasey113_0-1663342862468.png

 

I would expect the below results:

 

Wcasey113_0-1663343944568.png

 

 

However, the data is excluding the purchase from 2/28/2022. Results:

Wcasey113_0-1663343794213.png

 

 

 

Can you tell me why this is? What the solution would be? Any insight would be greatly appreciated as I hope to use this tool for a function with a larger data set.

 

I have attached the workflow and macro. The issue occurs in the red container box dataset.

 

Thank you once against for your assistance and time.

1 REPLY 1
apathetichell
19 - Altair

Without where this error occurs - we can't recreate the error - so the best advice would be "see if Amp is on - and if so turn off AMP"

Labels