Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Pass a record to a batch macro

priya_mohana_dhl
7 - Meteor

Hi,

 

I have a batch macro which takes text input. It has 1 row and 7 columns. I use update cell action for the control parameter.

priya_mohana_dhl_0-1635309998781.png

In the main workflow, I pass the input file with few records and call this batch macro. It works fine. Since each record has seven columns , I used update cell action. But, in another case, I have more than 30 columns. It will be difficult to use update cell. How do I process each record in this case? I need  to process all column values in my batch macro. I thought of using 'select records' in the batch macro and update the range using update value action. So, I converted the main workflow in to iteractive macro and call this batch macro till the end the records is reached (iteration = Count). Count is obtained from Count Records tool. I use Engine.iterationNumber and increment the iteration value. But, the itertion is '1' for the whole set of records. 

 

priya_mohana_dhl_1-1635313121716.png

 

Appreciate if anyone could help me to figure out the mistake.

 

Thanks,

Priya.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

But, in another case, 

3 REPLIES 3
atcodedog05
22 - Nova
22 - Nova

Hi @priya_mohana_dhl 

 

Set record id and batch it over record id that way only single record is processed each time.

atcodedog05_0-1635317355899.png

 

Hope this helps : )

priya_mohana_dhl
7 - Meteor

Will try it out and let you know if it works. Thanks.

 

 

priya_mohana_dhl
7 - Meteor

Thank you. It worked. I converted iterative macro it to main workflow. Instead of passing the iteration number, passed the RecordID. Simple and neat solution. Thanks again.

Labels
Top Solution Authors