Selecting one Row at a time

[Pickaxe]

Hello Everyone!

I am trying to create a workflow where a file with below inputs will be taken as input and one row should go through the flow and complete, then the next row should.

Area that I need a bit of expertise:

How to pass a single row of data one by one and completed untill the last row.

Batch/Iterative macro samples would be appreciated.

Table	one	two
1.	12315	12315
2.	123512	124512

Thanks,.

[grazitti_sapna]

Hi @Pickaxe , Here are few links and challenges which would be helpful in case you are new to macros. You can go through the guidelines provided and create a macro . In case you face any issue you can post it on community we will be able to answer your queries.

https://help.alteryx.com/20223/designer/iterative-macro

https://community.alteryx.com/t5/Weekly-Challenge/Challenge-12-Creating-an-HR-Hierarchy/td-p/36740/p...

https://community.alteryx.com/t5/Weekly-Challenge/Challenge-247-Pairing-Partners/td-p/683230

[Pickaxe]

Hi,

Thanks for the ref below.

I tried with the below example, and its not dynamically selecting one row at a time.

I get number of outputs right but its re-running the 1st record over again.

Regards.

[binuacs]

@Pickaxe Another option to process row-by-row is the batch macro. Attaching a sample workflow for your reference

[Pickaxe]

@binuacs Thanks for the workflow, but output is now consolidated and not separate, I'm using EMAIL tool as output btw.

Is there any other way to select one row at a time untill all the rows are completed. Need assistance.

Regards and Thanks,.

[binuacs · Accepted solution]

@Pickaxe The batch macro processes one record at a time. If you want to include any additional steps for a single row, you can add those steps inside the macro. only in the output, it is consolidating all the records. you can configure the batch macro something like below

[Pickaxe]

Excellent!, will try the above

Regards