Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

adamgaox
Contributor

store qvd

I see two ways of storing table into qvd files

1.STORE TAB INTO tab.qvd;

2.STORE TAB INTO tab.qvd(qvd);

is there any differences between these two methods?

Tags (1)
7 Replies
simone_spanio
Valued Contributor

Re: store qvd

Hi,

from the Documentation, this is the sintax of STORE statement:

store[ *fieldlist from] table into filename [ format-spec ];

format-spec ::= ( ( txt | qvd ) )

SO you can use (txt) or (qvd). If format-spec is omitted, (qvd) is used.

So we can assume that if you want store in a qvd, it's the same thing.

S.

Re: store qvd

Hi Adam,

Also note that, While loading the QVD into Qlikview, you should not omit (qvd). If you do so, you will get an error popup.

Correct:

LOAD * FROM tab.qvd (qvd);

Wrong:

LOAD * FROM tab.qvd;  (You will get an error)

Re: store qvd

No.

Re: store qvd

There is no difference between them. You can choose either of them.

Bur generally we use STORE TAB INTO tab.qvd;

t_chetirbok
Valued Contributor

Re: store qvd

Hi! There are other formats that can be written (txt,csv,qvd) but QVD is the default so the statement works without the suffix.

ramasaisaksoft
Valued Contributor III

Re: store qvd

Hi Adam,

1.STORE TAB INTO tab.qvd;

2.STORE TAB INTO tab.qvd(qvd);

both will gave the same result

but in second query u can save like

STORE TAB INTO tab.qvd(txt); it is also gave same result

i.e (QVD)/(txt) in which format u need to save that is ur wish else by default it is saved qvd format

hope i reach clear your doubt 80 % any way u can try once 

balkumarchandel
Valued Contributor II

Re: store qvd

Hi Adam

giving defining file type for QVD is not mandatory because QlikView understand it.

But when your will  store into some txt format like CSV you need to give file type.

ex.

STORE B into B.qvd;
STORE B into B.qvd(QVD);

Above both statements are same.

but below are different.

if you will use (txt) QV will load correct data but when you will not specify the format it will jot load data correctly it will be considered in xml format.

STORE B into csvB.csv(txt);
STORE B into wthoutcsvB.csv;

Thanks

BKC

Community Browser