QVDPath

[Anonymous]

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

[Anil_Babu_Samineni · Accepted solution]

Should be this?

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

[stabben23]

Hi, you have to add '\' last inQVDPath

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

[Anonymous]

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);

[devarasu07]

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

[Anil_Babu_Samineni]

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

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

[Anonymous]

Thank you guys for giving your valuable time.