Pass a record to a batch macro
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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,
Solved! Go to Solution.
- Labels:
- Batch Macro
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Set record id and batch it over record id that way only single record is processed each time.
Hope this helps : )
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Will try it out and let you know if it works. Thanks.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
