topic Re: QVDPath in QlikView

QVDPath

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

hello everyone ,

How to create QVD Path please explain step by step

i tried below script:

SET QVDPath = 'D:\Tech\QVD_PATH';

LOAD [Customer ID],

[Product ID],

[Customer Name],

City,

[Product Name],

[Order Date],

Sales

FROM

$(QVDPath)q1.qvd(qvd);

it shows an error "File Not Found"

then i tried

SET QVDPath = 'D:\Tech\QVD_PATH';

q1:

LOAD [Customer ID],

[Product ID],

[Customer Name],

City,

[Product Name],

[Order Date],

Sales

FROM

[yearly sales.xlsx]

(ooxml, embedded labels, table is Sheet1);

STORE q1 INTO $(QVDPath)q1.qvd(qvd);

its not showing any error but didn't get any qvd file.

help me

Thank You

Re: QVDPath

Anil_Babu_Samineni — Mon, 11 Dec 2017 12:37:57 GMT

Should be this?

STORE q1 INTO $(QVDPath)\q1.qvd(qvd);

Re: QVDPath

stabben23 — Mon, 11 Dec 2017 12:38:25 GMT

Hi, you have to add '\' last inQVDPath

SET QVDPath = 'D:\Tech\QVD_PATH\';

Re: QVDPath

Anonymous — Mon, 11 Dec 2017 12:42:20 GMT

thanks its working but is the right way?

SET QVDPath = 'D:\Tech\QVD_PATH';

q1:

LOAD [Customer ID],

[Product ID],

[Customer Name],

City,

[Product Name],

[Order Date],

Sales

FROM

[yearly sales.xlsx]

(ooxml, embedded labels, table is Sheet1);

STORE q1 INTO $(QVDPath)\q1.qvd(qvd);

Re: QVDPath

devarasu07 — Mon, 11 Dec 2017 12:43:54 GMT

Hi,

Try to do below steps,

keep your excel file under excel folder and QVD files under QVD folder (let say in D drive) and make sure the file exists

SET vQVDPath = '..\QVD';

SET vXLSPath = '..\excel';

LOAD [Customer ID],

[Product ID],

[Customer Name],

City,

[Product Name],

[Order Date],

Sales

FROM $(vQVDPath)\q1.QVD (qvd);

q1:

LOAD [Customer ID],

[Product ID],

[Customer Name],

City,

[Product Name],

[Order Date],

Sales

FROM $(vXLSPath)\yearly sales.xlsx (ooxml, embedded labels, table is Sheet1);

STORE q1 into $(vQVDPath)\q1.QVD (qvd);

Thanks,

Deva

Re: QVDPath

Anil_Babu_Samineni — Mon, 11 Dec 2017 12:44:15 GMT

Yes, Your STORE command should work when you use this?

SET QVDPath = 'D:\Tech\QVD_PATH\';

Re: QVDPath

Anonymous — Mon, 11 Dec 2017 12:46:56 GMT

Thank you guys for giving your valuable time.