Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

cancel
Showing results for 
Search instead for 
Did you mean: 
JoannaM
Contributor III
Contributor III

Export data in script editor to Excel

Hi all

How can I export certain data directly through script editor into excel (Test.xlsx on my Desktop)?

What is the correct store to command?

Temp:
LOAD * INLINE [
Name, Country
Meyer, Germany
Jung, Korea
Ansani, France
Milo,France
];

 

Thanks a lot.

Best regards,

Joanna

12 Replies
JoannaM
Contributor III
Contributor III
Author

Hi Anku

I did this:


Temp:
LOAD * INLINE [
Name, Country
Meyer, Germany
Jung, Korea
Ansani, France
Milo,France
Mine, Germany
];

Store Temp into [H:\Test.csv]

(TXT, delimiter is ',');

and I got that:

JoannaM_0-1634633405506.png

Thanks a lot for the help.

BR, Joanna

Anku
Contributor III
Contributor III

@JoannaM 

Do one thing, first import any file from the required location and then use that path to store you csv in the same way.

In your case, you're using the drive name however Qlik uses Lib.

Also, avoid extracting and store the same file and location.

JoannaM
Contributor III
Contributor III
Author

Hi Anku

Thanks to your input I found out, that the file has to be in a special drive. Should be working now.

BR, Joanna