Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to eliminate 'qvds' from script

Hi,

in order to avoid field name conflicts I use a lot of 'store' sentences creating a lot of qvds.

At the end I have many useless qvds.

Is there a way to eliminate them at the end of the script?

Thanks

13 Replies
Anonymous
Not applicable
Author

Concatenation is not a real problem - NoConcatenate prefix helps there. Concerning Exists() (and Peek, FieldIndex, LookUp), You are right, there might be problem if one wants to differentiate between tables ... then Your recommendation - QUALIFY comes to help

kuba_michalik
Partner - Specialist
Partner - Specialist

Hey, let us neat freaks have our fun. We're people too ¬¬

Not applicable
Author

Hi everybody,

I do not like too much the qualify/unqulify option because it takes me a lot of time to control many names in memory even if they are different. I prefer get rid of them temporaly using 'store'/'drop'. Is true that using 'store'/'drop' the confusion goes from the script to the folder where I place the qvds because some of them are trash but others are usefull for other scripts. Maybe create a folder called 'trash' would be a good and simple idea.

Thank you.


its_anandrjs
Champion III
Champion III

And also you can use

Drop Tables TableName1.qvd,TableName2.qvd....TableNameN;

if remove only from model

Regards

Anand