Loop throug items on an Excel file.

brunolelli87 — Wed, 25 Nov 2020 16:16:04 GMT

Hello guys,

I have an Excel file (as you can see below), with 2 columns, that are: Company and Ticker.

I would like to run a loop in my script, but 1 LOAD looping through Company and another LOAD looping through Ticker?

Is it possible?

Thanks

Re: Loop throug items on an Excel file.

vamsee — Wed, 20 May 2020 21:26:34 GMT

The below solution lets you loop with Company first, then nested loop of Ticket in it.

Load Company, Ticket

From Table A;

Let vCompanyNo=1;
For vCompanyNo= 1 to NoofRows('A')
LET vCompanyLoop= Peek('Company', vCompanyNo-1, 'A');

TRACE with $(vCompanyLoop);

Let vTickerNo=1;
For vTickerNo= 1 to NoofRows('A')
LET vTickerLoop= Peek('Ticker', vTickerNo-1, 'A');

TRACE $(vTickerLoop);

******

Script

*****

Trace $(vTickerLoop) End;

Trace $(vCompanyLoop) End;

Trace Both Loops Completed;