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.
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
Pilsner
10 - Fireball

I think you want to use a batch macro, I have connected your macro to this workflow which should allow the data to be processed in batches, I hope this helps:

Screenshot 2023-07-24 163527.png

mquast
8 - Asteroid

@Pilsner Can you attach the workflow to the forms so I can see the changes 

 

Pilsner
10 - Fireball

Yes, this is the workflow:

mquast
8 - Asteroid

@Pilsner the Macro seems to be working, but it is losing the format. When I filter to only run Group 1 seven times it works, but when it runs all 7 groups is complies wrong. I've updated the workflow to have the correct order being inputted and I've included the final output in the excel file.

binuacs
21 - Polaris

@mquast what is the logic to calculate the output? I can see 7 groups (each group contains 91 records). in the output file, why are you taking only 39 columns after transposing and cross-tabing the data? 

mquast
8 - Asteroid

@binuacs the other 61 columns of data are calculated using a different table then joined. The process is the exact same for the first 39 and the last 61. In theory I would like the whole calculation to be in one macro, but I was going to figure out the first half then the 2nd half would be nearly the same. 

 

mquast
8 - Asteroid

@binuacs This is everything you should need. 

binuacs
21 - Polaris

@mquast The macro you created working for you in the first set of groups? 

mquast
8 - Asteroid

@binuacs When I run a single group through the macro, it works. When I run with macro with 2 or more groups I lose formatting and it is incorrect.

Labels