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