Looping a Query to Run for Multiple Deduction Codes

unknown

Good Afternoon All,

I am attempting to build an automation that will query a number of different Deduction Codes.  If there was a deduction in the most recent pay period it would then run a Lawson Transaction Node to run the applicable PR275 - Deduction Report or PR276 - Employee Deduction Report.  I only need the query to pull the 1st record for each deduction code, but need to run again for the next deduction code in the sequence.  For example:

1st Run of Query - Deduction Code BN01

2nd Run of Query - Deduction Code BN02

etc.

On the end node of the query I know to put in formula to stop it after the 1st record pulls, but is there a way to make it loop to run for the next deduction code?  I am thinking an Array in the "For Each" node is needed, but not sure how to assemble the JavaScript.  Any help would be greatly appreciated.  Thank you!

jreese

What if you created a list of all the deduction codes you wanted to query and then read through the list with the Data Integrator node and place the rest of your flow within this loop? Once it completes for the first deduction it would read in the second code, etc.