Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
Hi,
It is the Store command. You can change the extension of the file at the end (example below using csv)
Store TableName into [lib://ConnectionName/FileName.csv] (txt);
Hi Gui_Approbato
Thanks for the answer.
I tried the path below but it doesn't work. Connection not found: C:...
Store Temp into [lib://C:/Users/myname/Desktop/Test.csv] (txt);
Did I forget to link something somewhere?
Thanks a lot.
BR, Joanna
@JoannaM Did you create a connection for this path folder - C:/Users/myname/Desktop/ ?
If yes, then use the name of the connection:
Store Temp into [lib://[ConnectionName]/Test.csv] (txt);
Thank you for the input. I manged that yes. Now the error message is gone. When I open now the XLSX file remotly on my desktop the file is empty. I wanted the data to be stored automatically in the XLSX file so I could use the data in the XLSX for further calculations. Is that no possible ?
Thanks a lot.
BR, Joanna
@JoannaM Can you share the script you used to create the file? And did you get an error message when you try to open the file or just empty file?
I have the following script:
Temp:
LOAD * INLINE [
Name, Country
Meyer, Germany
Jung, Korea
Ansani, France
Milo,France
Mine, Germany
];
store Temp into [lib://AttachedFiles/Test.xlsx];
My file Text.xlsx file is stored on my folder H:\Test.xlsx.
When I open the folder on my H drive, then the XLSX file is empty.
What am I doing wrong?
BR, Joanna
Looks like XLSX format is not supported.
You can try this (xls format):
Temp:
LOAD * INLINE [
Name, Country
Meyer, Germany
Jung, Korea
Ansani, France
Milo,France
Mine, Germany
];
store Temp into [lib://AttachedFiles/Test.xls](txt);
This is working for me.
Eli.
Hi Eli
I tried the way you did. When I open the path and click on the file attached the data is there:
However, when I try to open the XLS file on my H drive where I saved it, the file is empty.
Thanks.
BR, Joanna
Try below
Temp:
LOAD * INLINE [
Name, Country
Meyer, Germany
Jung, Korea
Ansani, France
Milo,France
Mine, Germany
];
Store Temp into [path/filename.csv]
(TXT, delimiter is ',');