Help Looping a Process Model

Thanks for all the help I received last time I posted here. I was able to complete an export to excel from CDT.

Now I would like to write a loop around the export process which will reference an array of unique ids to form the foundation for the data pull. The original model takes just on ID, hence the loop. I'm not sure if this is the best way of doing it. Any suggestions would be helpful. I've added the 'increment constant node' and the 'restart all nodes'. I think this method would work but that is also why I am posting. I have a sail form to accept the input for the array of unique ids but I'm not sure if that should be the process start form or a 'user input node'.

OriginalPostID-267502



  Discussion posts and replies are publicly visible

Parents
  • Thanks for the insight. I think I would like to stick with the CDT process because the excel template that I'm populating is complex and requires several aggregations. It's working well so I was hoping to reuse that work by looping through it. Right now the process model its taking a table id, populating a multi-sheet excel template, and then exporting the file via email. My plan, for now, would be to loop that process so that multiple emails would be sent by indexing an array of IDs.
Reply
  • Thanks for the insight. I think I would like to stick with the CDT process because the excel template that I'm populating is complex and requires several aggregations. It's working well so I was hoping to reuse that work by looping through it. Right now the process model its taking a table id, populating a multi-sheet excel template, and then exporting the file via email. My plan, for now, would be to loop that process so that multiple emails would be sent by indexing an array of IDs.
Children
No Data