In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
Start 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
binu_acs
21 - Polaris

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

mquast
8 - Asteroid

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

Labels
Top Solution Authors