Use data from one loop into another loop

[#1]

Hi All,

In step 1 Using For...Next loop I get a set of one column data (internet addresses) which, in step 2,  I'd like to use as sources for another loop to get data from there

Step 1

For i=0 To 3

LET C = 'Internet_file_part_1' & $(i) & 'Internet_file_part_2 (fix, utf8)';

Load Data

From $(C);

Next

Step 2 - ?

Any idea appreciated.

Kind regards,

Przemek

[rwunderlich · Accepted solution]

Use NoOfRows() and peek() functions to walk through the loaded table in the second loop.

Rob