Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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);
Have you tried reading the error message? What was that? Try like:
....
FROM
[CORE_AUP\Aedup_April.xlsx]
(ooxml, embedded labels, table is Sheet4);
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.
Thanks Tresesco