Is there a way to use outer loop variables to enter text inside of inner loop?

Follow

jllTCG

• December 14, 2020 02:51

I want to use two nested loops in order to enter data from a matrix. (One loop loops through cities, and the other loops through dates). That way I have data for each city on each date. How can I enter the city and the date inside of the inner loop? Currently if I hit "Use Text In Loop" then it uses the text from the loop that surrounds the element. I want to use the outer most loop instead.

0

• 

  Brian

  • December 18, 2020 10:20

  Hi jllTCG,

  Thank you for reaching out.

  Yes if you want to get data for each city on each date, you can just use two nested loops to achieve the goal, but I'm not sure what do you mean by "then it uses the text from the loop that surrounds the element. I want to use the outer most loop instead." Could you please kindly explain a bit more? Any examples would be helpful.

  Best regards,

  0

  Comment actions Permalink
• 

  Proelectro

  • April 16, 2021 13:05

  Can you explain in detail how to do that. Because I am also encountering same issue 

  0

  Comment actions Permalink

Please sign in to leave a comment.