Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
holguinmora
New Contributor III

Store Function

Hi to all!!!

I´m having a small problem using the store function, on the next image the content of a table, then the script that I´m using to export the table to a CSV file and finally the error that I´m getting when I try to open the file with excel to validate the info.

Any help? Any ideas?

Captura de Pantalla 2019-07-09 a la(s) 5.09.23 p. m..png

Script:

[B]:
LIB CONNECT TO 'Dropbox - alejandro@inflexion.com.co';

LOAD
CodigoB,
NombreB
FROM [lib://Dropbox - alejandro@inflexion.com.co/Pruebas/Libro B.xlsx]
(ooxml, embedded labels, table is Hoja1);

store [B] into [lib://Prueba Destino/Tabla3.csv (txt)]

Excel error: 

Captura de Pantalla 2019-07-09 a la(s) 5.36.37 p. m..png

 

1 Solution

Accepted Solutions
Partner
Partner

Re: Store Function

Hi Holguinmora,

You are able to store and don't store into Dropbox itself? How big in the csv file that you are trying to open?

Jordy

Climber

Work smarter, not harder
2 Replies
Employee
Employee

Re: Store Function

try removing the txt.

..

store [B] into [lib://Prueba Destino/Tabla3.csv];

Partner
Partner

Re: Store Function

Hi Holguinmora,

You are able to store and don't store into Dropbox itself? How big in the csv file that you are trying to open?

Jordy

Climber

Work smarter, not harder