Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Store Function

Good morning to all!!!

I´m trying to download the next table into my Mac DropBox folder, on the final image the path that I get form the dropbox folder from my Mac:

Can someone give me a hand with the script to be able to do so?

[C]:

LOAD
CODIGOC as Cod,
NOMBREC as NomC
FROM [lib://Dropbox - alejandro@inflexion.com.co (qlikcloud_qlikid_aholguininflex)/Pruebas/Libro C.xlsx]
(ooxml, embedded labels, table is Hoja1);

STORE [C] into lib://alejandroholguin/Dropbox/Sample_1.csv (txt);

 

Path.png

 

 

Labels (2)
3 Replies
JordyWegman
Partner - Master
Partner - Master

Hi,

What happens when you do this?

[C]:

LOAD
CODIGOC as Cod,
NOMBREC as NomC
FROM [lib://Dropbox - alejandro@inflexion.com.co (qlikcloud_qlikid_aholguininflex)/Pruebas/Libro C.xlsx]
(ooxml, embedded labels, table is Hoja1);

STORE [C] into lib://Dropbox - alejandro@inflexion.com.co (qlikcloud_qlikid_aholguininflex)/Pruebas/Sample_1.csv (txt);

Jordy

Climber

Work smarter, not harder
Anonymous
Not applicable
Author

Hi

Unfortunatelly when I add the code, I get the next section: (qlikcloud_qlikid_aholguininflex) in red and the next error text:

Unexpected token: 'qlikcloud_qlikid_aholguininflex', expected one of: 'qvd', 'qvx', 'txt', 'delimiter'

When I add brakets to the begining and end I get the next error:

[STORE [C] into [lib://Dropbox - alejandro@inflexion.com.co (qlikcloud_qlikid_aholguininflex)/Pruebas/Sample_1.csv (txt);]

Error: Unexpected token: 'ooxml', expected one of: 'qvd', 'txt', 'qvx', 'delimiter'

Any ideas? Or ways to solve this?

Regards
JordyWegman
Partner - Master
Partner - Master

Just making sure, you want to store back into Dropbox right?

Jordy

Climber

Work smarter, not harder