Store and drop tables in a loop

Peony — Wed, 03 Nov 2021 09:11:11 GMT

Hi All.

Here I have some issue with store and drop process in a loop.

I have several tables in a load script and want to store and drop them using a loop. Like below.

Answer:
LOAD *
FROM Answer;

Question:
LOAD *
FROM Question;

Set vTransformFinal = '[QVD\Transform\Full\';

let vTables = NoOfTables();

Let i = 0;

Do While i < vTables

Let vTable = TableName(i);

Store $(vTable) into $(vTransformFinal)$(vTable).qvd];
Drop Table $(vTable);

i = i+1;

Loop;

But for some reason after first iteration I received such error:

But I see that QVD for Answer table was stored even after I get this error. But table can't be dropped.

After this message script failed.

Could you please help me to find what am I doing wrong with my code and how to fix it?

Re: Store and drop tables in a loop

Peony — Wed, 03 Nov 2021 11:16:14 GMT

Solved! Should be Let vTable = TableName(0);

topic Store and drop tables in a loop in QlikView

Store and drop tables in a loop

Re: Store and drop tables in a loop