topic Re: How to eliminate 'qvds' from script in QlikView

How to eliminate 'qvds' from script

Fri, 24 Oct 2014 08:54:21 GMT

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

Re: How to eliminate 'qvds' from script

alexandros17 — Fri, 24 Oct 2014 08:56:02 GMT

Probably you can create table in memory instead of qvd, in the same way you can refer to tables in memory and when you do not need them anymore use Drop table instruction.

Re: How to eliminate 'qvds' from script

kuba_michalik — Fri, 24 Oct 2014 08:58:39 GMT

Sure, using EXECUTE and operating system command DEL. This will mark the script as unsafe (EXECUTE could potentially do anything), although you can disable the warning in user preferences. If you are developing for a QV Publisher environment, I'd create a supporting task to wipe the qvds after reload.

Re: How to eliminate 'qvds' from script

Fri, 24 Oct 2014 09:34:46 GMT

Hi,

if I understood properly, using memory tables I have to deal with many equal field names at the same time this is why use 'store' + 'drop table' maybe is there a better way to avoid the conflict but I do not know it.

As for EXECUTE and DEL, could you please tell me an example to erase a file.qvd placed in c:\ for example?

thanks a lot

Re: How to eliminate 'qvds' from script

Gysbert_Wassenaar — Fri, 24 Oct 2014 09:38:06 GMT

And on the next reload they will be created again overwriting the current ones. So what? Disk space is cheap these days. Why bother cleaning them up? Just store them in a work folder and leave them there unless you really need the disk space.

Re: How to eliminate 'qvds' from script

simondachstr — Fri, 24 Oct 2014 09:39:04 GMT

How about the QUALIFY statement? This will precede each fieldname with its tablename, avoiding having to deal with many equal field names at the same time..

Re: How to eliminate 'qvds' from script

markodonovan — Fri, 24 Oct 2014 09:47:57 GMT

Hi Luis,

What about renaming the fields that are clashing to something more descriptive ?

Other than this you could use the QUALIFY\UNQUALIFY statements that have already been mentioned.

Or split the creation of the qvds into more than one document.

Thanks

Mark

FREE QlikView Training Course -> http://www.techstuffy.com

Re: How to eliminate 'qvds' from script

kuba_michalik — Fri, 24 Oct 2014 09:53:55 GMT

EXECUTE cmd.exe /c DEL C:\file.qvd

Re: How to eliminate 'qvds' from script

Anonymous — Fri, 24 Oct 2014 11:15:44 GMT

Hi Luis,

I would prefer Alessandro's recommendation. There are no field name conflicts until the script ends and QlikView begins building associations. Everything is in RAM, i.e. fast. I use this approach a lot.

Good Luck

Re: How to eliminate 'qvds' from script

simondachstr — Fri, 24 Oct 2014 11:25:28 GMT

I disagree - how about autoconcatination of tables with the same field names, Sergey? Or using a where exists(Fieldname) clause in a load.

Re: How to eliminate 'qvds' from script

Anonymous — Fri, 24 Oct 2014 11:42:11 GMT

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

Re: How to eliminate 'qvds' from script

kuba_michalik — Fri, 24 Oct 2014 21:28:40 GMT

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

Re: How to eliminate 'qvds' from script

Mon, 27 Oct 2014 08:38:40 GMT

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.

Re: How to eliminate 'qvds' from script

its_anandrjs — Mon, 27 Oct 2014 08:42:35 GMT

And also you can use

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

if remove only from model

Regards

Anand