topic Re: Save the Data into Qvd format in QlikView

Save the Data into Qvd format

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

Good Afternoon Everyone,

Can anyone please me in saving my excel data into QVD format?

I am trying below code in QlikView but not able to get the desired output.

Raw_Data:

LOAD IC01,

GID,

SITE_ID,

SCORE,

CREATED_BY_USER,

CREATED_ON,

Year(CREATED_ON) as Year,

Month(CREATED_ON) as Month,

Time,

[Actual Duplicate],

[Issue source],

BY_REGION

FROM

CORE_AUP\Aedup_April.xlsx

(ooxml, embedded labels, table is Sheet4)

STORE Raw_Data INTO C:\Users\LJ@o.com\Desktop\Bijay Doc\Qlick View\Mycontactsdetails.qvd(qvd);

tresB — Mon, 29 May 2017 09:27:03 GMT

Have you tried reading the error message? What was that? Try like:

....

FROM

[CORE_AUP\Aedup_April.xlsx]

(ooxml, embedded labels, table is Sheet4);

Anonymous — Mon, 29 May 2017 09:27:49 GMT

Hello Friend,

I think, that the problem is with one missing semicolon :

CORE_AUP\Aedup_April.xlsx

(ooxml, embedded labels, table is Sheet4) ;

STORE Raw_Data INTO C:\Users\LJ@o.com\Desktop\Bijay Doc\Qlick View\Mycontactsdetails.qvd(qvd);

If you have still the problem, please add error message.

Regards

Jacek.

Anonymous — Mon, 29 May 2017 09:33:41 GMT

Thanks Tresesco