topic mutiple table Load error in QlikView

mutiple table Load error

didierodayo — Wed, 30 Aug 2017 01:16:09 GMT

Hi All,

am tryng to load multiple table from Sql with the script below. The script works fine and loads all the table which it stores into qvd but in the end I receive the following error.

Tables:
Load * Inline [name
table1
table2
table3
table4
table5
];

For i = 1 to NoOfRows('Tables')
Let TN = Peek('name',$(i),'Tables');
TRACE Processing File: $(TN).qvd;
$(TN):
LOAD*;
SQL SELECT *
FROM $(TN);

STORE $(TN) into $(vQVDExtractPath)Tables_$(TN).qvd (qvd);
Drop Table $(TN);
Next i;

ErrorCode:

Unknown statement

LOAD*

Any idea why I am receving the error in the end?

Thanks

Re: mutiple table Load error

Anil_Babu_Samineni — Wed, 30 Aug 2017 01:31:26 GMT

May be declare this statement like

Select * from ...;

Load * resident $(TN);

Re: mutiple table Load error

didierodayo — Wed, 30 Aug 2017 01:44:49 GMT

Hi Anil that is also returning the same error.

For i = 1 to NoOfRows('Tables')

Let TN = Peek('name',$(i),'Tables');

TRACE Processing File: $(TN).qvd;

$(TN):

SQL SELECT *

FROM $(TN);

LOAD* Resident $(TN);

STORE $(TN) into $(vQVDExtractPath)Tables_$(TN).qvd (qvd);

Drop Table $(TN);

Next I;

Re: mutiple table Load error

kenphamvn — Wed, 30 Aug 2017 02:04:04 GMT

Please try this

For i = 0 to NoOfRows('Tables') -1

instead

For i = 1 to NoOfRows('Tables') -0

Re: mutiple table Load error

didierodayo — Wed, 30 Aug 2017 02:15:03 GMT

Thanks An, that is what it was.