Pass a record to a batch macro

[priya_mohana_dhl]

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.

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. 

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

Thanks,

Priya.

But, in another case, 

[atcodedog05 · Accepted solution]

Hi @priya_mohana_dhl 

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

Hope this helps : )

[priya_mohana_dhl]

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

[priya_mohana_dhl]

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.