topic How to save data in xls format fron script editor in QlikView

How to save data in xls format fron script editor

Fri, 07 Nov 2014 19:04:47 GMT

Hi,

I need to read a data from qvd file and save them in xls format.

I just type the next code

Custumer:

Load ID,

Name

From $(vRuta)Custumer.qvd(qvd);

Store * From Customer into $(vDestino)Customers.csv(txt);

In these way it don't work. only save the save qvw file in txt format.

Too i just type...

Store Customer into $(vDestino)Customers.csv;

and didn't work.

Anyone can help me?

Thanks!!!

JonnyPoole — Fri, 07 Nov 2014 19:10:46 GMT

Could it be spelling ? Your table is Custumer in your script. But the store says Customer.

Use whichever is the right table name:

Store Customer into $(vDestino)Customers.csv (txt);

Store Custumer into $(vDestino)Customers.csv (txt);

ps: what is $(vDestino) ? Something like 'C:\Folder\' I hope...

Fri, 07 Nov 2014 19:30:58 GMT

Sorry peoples !!!

My script code is working correctly.

the issues was that I was looking for in another folder.

My sintax was verty well.

Fri, 07 Nov 2014 19:31:48 GMT

Sorry peoples !!!

My script code is working correctly.

the issues was that I was looking for in another folder.

My sintax was verty well.