Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
kartik
Contributor III
Contributor III

Not able to store the Employee Table

Employee:
LOAD
EmpID,
"Last Name",
"First Name",
Title,
"Hire Date",
Office,
"Extension",
"Reports To",
"Year Salary"

FROM [lib://DataFiles/EmpOff.xls]
(biff, embedded labels, table is Employee$);

Concatenate

LOAD
EmpID,
"Last Name",
"First Name",
Title,
"Hire Date",
Office,
"Extension",
"Reports To",
"Year Salary"
FROM [lib://DataFiles/Employees_New.xls]
(biff, embedded labels, table is Employee$);

store Employee into C:\Users\14418\Desktop\qwt\qvd_Extraction\Employee_table.qvd(qvd);

Also used this, down below

store Employee into lib\\C:\Users\14418\Desktop\qwt\qvd_Extraction\Employee_table.qvd(qvd);Screenshot (34).pngScreenshot (35).png

8 Replies
anat
Master
Master

Can you try to store qvd by giving other path

kartik
Contributor III
Contributor III
Author

Yes I Tried.. 

here it is.Screenshot (36).png

MayilVahanan

Hi Kartik,

You can't store into local desktop from "Qlik Cloud".

You can store in the cloud itself (in Data Files folder)

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
kartik
Contributor III
Contributor III
Author

Thanks Mayil. 

Got it..

 

kartik
Contributor III
Contributor III
Author

Hi Mayil,

In cloud, from where to copy the path ?

Please share screenshot. It will be very helpful.

 

Regards

Kartik Semwal

kartik
Contributor III
Contributor III
Author

 

See unable to find this data files folder. 

 

Screenshot (47).pngScreenshot (48).png

MayilVahanan

Hi 

Try like below

Store table into [lib://urspaces:DataFiles/FileName.QVD](qvd);

It will store into ur space like below

MayilVahanan_0-1640768696763.png

 

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
kartik
Contributor III
Contributor III
Author

I did it. But not by this way.

What I did is, actually made a txt document and simply write something un-useful on it.

then load that txt in Qlik sense data load script.

then it gave me the path and copied that and use that path to store my table.

And It worked. Now I can see that Qvd in Qlik sense cloud(Catalog) itself .