Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Save the Data into Qvd format

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

3 Replies
tresesco
MVP
MVP

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
Not applicable
Author

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
Not applicable
Author

Thanks Tresesco