for..next around a table

[surajap123]

Hi All,

In the attached demo app, If you open Script editor 'orders' tab in table [Order Detail] I see the below code-

For i = 1 to 3 ...NEXT

I am wondering, what the for..next doing to the [Order Detail] table and where the i = 1 to 3 came from.

Please explain me with an example.

Thanks!!

Regards,

Suraj

[MK_QSL · Accepted solution]

There could be three Worksheet in AdventureWorks.xls file

SalesOrderDetails1

SalesOrderDetails2

SalesOrderDetails3

Instead of loading three different load as below

[Order Detail]:

LOAD SalesOrderID,

     SalesOrderDetailID,

     ...

     CostAmount

FROM

[..\Database\AdventureWorks.xls]

(biff, embedded labels, table is SalesOrderDetails1)

WHERE EXISTS(SalesOrderID);

here For Next Loop is used...

When i = 1 SalesOrderDetails1

When i = 2 SalesOrderDetails2

etc..

Hope this helps...

[anbu1984]

QVD Generator using For..Next Loop in QlikView – Part II - QlikView Blog, QlikView Videos and Tips a...