How to reset For Each loop

 0 Replies
 0 Subscribed to this topic
 52 Subscribed to this forum
Sort:
Author
Messages
JasonP
Advanced Member
Posts: 28
Advanced Member

    Im using a For Each loop to loop through an array which contains a list of strings such as COMPANYNO|DATE.  When my SQL1 company equals Company from Data Iterator which is being used to split the string, my for each never really ends.  When the second record from SQL1 hits, we go back into the For Each loop but the iteration doesn't reset.  So in the first pass, we find a match on iteration 3, we exit the for each and data iterator. on SQL1 second record, the for each starts where it left off.  I would like to Reset the For each every time I come in but my assign node isn't working, is this even possible, thanks in advance, see attached.

     

    I'm to reset it ForEach7740_iterationNumber = -1, Ive also tried setting to zero and 1 and doesn't seem to work.

    Attachments