Iterative Macro (Maybe)

[mquast]

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. 

[Pilsner]

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:

 

[mquast]

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

[Pilsner · Accepted solution]

Yes, this is the workflow:

[mquast]

@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]

@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]

@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]

@binuacs This is everything you should need. 

[binuacs]

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

[mquast]

@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.