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

Alteryx Designer Desktop Discussions

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

Iterative Macro (Maybe)

mquast
8 - Asteroid

I'd like to sample or filter off the first 91 rows then do a transformation, but I need to do this process multiple times. I was thinking to have an Iterative Macro update a field so that the Sample tool will filter off 91*Iteration and then I would take the bottom 91 which would be the newest data. I've tried multiple ways, but I cannot get the macro to work correctly. 

11 REPLIES 11
binuacs
21 - Polaris

@mquast Are you using Sheet1 and Sheet2 as input in your workflow? 

mquast
8 - Asteroid

@binuacs Yes, Sheet1 Is the input for the top stream, Sheet2 is for the bottom stream.

Labels
Top Solution Authors