Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

LOAD statements in for loops

Hi all,

Just a quick one in case anyone knows. I am loading a table in a for loop in order to identify some values and use them one by one in another loop. For this to work I pretty much need the table to be flushed away after each iteration rather than just keep all rows that are added after each iteration. What's the best way to achieve this?

Thanks all in advance

Tags (4)
2 Replies
richard_chilvers
Contributor III

Re: LOAD statements in for loops

Hi Joseph

Its hard to be certain about what you're trying to do without a bit more detail.

But it seems to me you want to empty a table and then re-use it. Would it be possible use

DROP TABLE xxxxxx

and then redefine it ?

Just a thought.

Regards

Not applicable

Re: LOAD statements in for loops

Hi Richard,

Apologies I did not express it correctly and the error appeared to be somewhere else! Thanks anyway

Community Browser