Selecting one Row at a time

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

Macros

Iterative Macro

Accepted answers

@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

All comments

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/page/2

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

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.

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

Combine_Row_By_Row_130223.yxzp

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

@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

Excellent!, will try the above

Regards

Quick Links

Tags

This months top contributors

AkimasaKajitani 389

michael_weaver 335

Hollingsworth 335