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,.
Solved! Go to Solution.
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-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
@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,.
@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