Get Iterator index of previous loop

[koneubauer]

I created an Automation in which my first step is executing a database-query which returns start and destination coordinates and other relevant data per row.
The next step is querying a Routing-Api which returns the distance between start and destination from step 1. On this step, i have enabled a loop which iterates over the rows of the first databse-query.
The third step is a create-row element with a loop which should insert the distance with the other data from the first step (id, name, date,...) into a table.
I can access the results of the Routing-Api query and i can also access the result-set from step 1. However, i would need an iterator index for getting the correlating data from step 1 to match the calculated distance of step 2
Is there any way to get the index of the loop of step 2 and use it in step 3 to get the matching data from step 1?
I have highlighted the value which would have to be the iterator index for it to work. (step_3)

[ConorWebb96]

Hey @koneubauer,

I would suggest that you look at the JS SCRIPTING action that you can add, with this you may be able to do the more complicated logic that you're after related to steps 1 and 2 you talked about. As I don't have your configuration I'd suggest doing something along these lines for the additional step after 1 and 2;

  const dataStep1 = {{ steps.1.response }};

  const resultsStep2 = [];
  for (let index = 0; index < dataStep1.length; index++) {
    const row = dataStep1[index];
    const start = row.start;
    const destination = row.destination;
    const distance = {{ steps.2.items }};
    const result = { distance: distance, otherData: row.otherData };
    resultsStep2.push(result); // output the combined data related to one another.
  }

From the above you could then create a row with all the relevant data. For the above you likely will need to change it to meet your specific needs.

I hope this at least points you in the right direction!

[koneubauer]

Thanks a lot!