Macro to process ALL records, 4 at a time

Hi.

Need some help. I would like to process all records of my input, though 4 records at a time.

I've used a sample tool configured with 'First N (4) rows', then a Join to match, then outputting unmatched remaining records to an external file...to repeat the process. No luck getting either variation of macro (standard, batch, iterative) to loop through the records 4 at a time.

I suspect that i may need to crosstab/transpose the sample 4 records into a single row/record prior to passing through a macro, though based on some conditions, after the 4 are processed, may need to introduce the next 1 or 2 additonal record (record(s) #5, 6)

For example, 100 records, each with a single value of 1-10, process records #1-4, possibly #5, repeat same till all 100 are done.

Macros

Accepted answers

Christina_H

@HomesickSurfer I think you can do what you need with either a batch macro or an iterative macro. You currently have it set up as a batch macro.

To do this with a batch macro, you need to identify the batches outside the macro, then feed in all the data along with a list of the batches. No need to sample to the first 4 rows within the macro, they will be fed in 4 at a time.

Alternatively, with an iterative macro you would sample the first 4 rows then feed them out of a separate output, and iterate the remaining records. The macro would have two separate outputs, and you need to specify in the interface designer which output gets iterated back to the input.

You also don't have a macro input tool in your macro, you seem to be trying to update a text input with action. Convert your text input to a macro input and it should work much better.

I'm happy to help further, but the best approach might depend on what you actually want to do with your data. I assume the current process is a simplification for sharing, but what you're doing is possible without any macros at all!

DawnDuong

Re-attached here. @HomesickSurfer

Process 4 records at a time.yxzp

All comments

DawnDuong

hi @HomesickSurfer

I don't 100% understand the description TBH. Perhaps you can post a sample data input and expected output?

Coincidentally, someone just asked another question about processing 4 records, you may want to check out the responses here https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Split-output-to-multiple-sheets-based-on-a-column-value-and-the/td-p/834780

Dawn.

HomesickSurfer

Hi @DawnDuong

The referenced post doesn't satisfy what i am seeking. Thank you for looking into my request.

I've attached a packaged workflow, macro and input data. My sample doesn't loop/iterate

workflow.yxzp

input.xlsx

Christina_H

@HomesickSurfer I think you can do what you need with either a batch macro or an iterative macro. You currently have it set up as a batch macro.

You also don't have a macro input tool in your macro, you seem to be trying to update a text input with action. Convert your text input to a macro input and it should work much better.

Christina_H

If it helps, here is your sample set up to work as a batch macro.

workflow.yxzp

HomesickSurfer

Thank you @Christina_H

I'll try your proposed solution and respond accordingly.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703