We’ve extended Inspire Early Bird Pricing until March 1. Register now and enjoy 20% off conference passes and 10% off training passes. P.S. Don’t forget to bring friends! When you sign up for five or more tickets, you get an extra 20% discount on conference passes. 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
20 - Arcturus

@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
20 - Arcturus

@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