Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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