In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

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