topic Re: Export from Script into Tab delimited file? in QlikView

Export from Script into Tab delimited file?

avastani — Tue, 10 Nov 2009 03:54:30 GMT

Is it possible to export to a tab or CSV delimited file from LOAD Script or MACRO instead of Export to Excel?

AW:Export from Script into Tab delimited file?

Tue, 10 Nov 2009 04:05:33 GMT

you can export a tabe with the ID EXORT with the follow MACRO:

sub exportList
set obj = ActiveDocument.GetSheetObject("EXPORT")

TableName = v.GetContent.String

exportPfad = "C:\QlikView Storage\Production\Adressmanagement_BGZS\08-script\"

FileName = "filename.txt"
'obj.Export FileName, ";"

obj.Export FileName, ";"
obj.ServerSideExport FileName, ";"

end sub

use the function Export for local export ot the function ServerSideExport for export on the server.

AW:Export from Script into Tab delimited file?

prieper — Tue, 10 Nov 2009 04:07:39 GMT

Manual: Rightclick and then Export ... instead "Send to Excel". In the Filemenu then you can choose formats.
From the script you can use the STORE-command (with undocumented function) and save as .csv or .txt.

Peter

AW:Export from Script into Tab delimited file?

avastani — Tue, 10 Nov 2009 04:28:58 GMT

STORE-command (with undocumented function) and save as .csv or .txt

--can't use STORE <table> INTO <filename>.csv (csv);

however, .txt works, but it is still encrypted which is not good.

AW:Export from Script into Tab delimited file?

avastani — Tue, 10 Nov 2009 05:37:43 GMT

Hi Dirk,

Tried the suggestion and it does not work either. It fails on set obj = ActiveDocument.GetSheetObject("EXPORT") where my object is a tablebox with id TB01.

AW:Re: AW:Export from Script into Tab delimited file?

Tue, 10 Nov 2009 13:06:44 GMT

Hi Amir!

EXPORT is only a example for a object id. You must apply

obj = ActiveDocument.GetSheetObject("TB01")

or change the ID in the object properties.

Thanks for your resolution with the STORE-command. I will test it today, too.

Export from Script into Tab delimited file?

Wed, 02 Jun 2010 11:10:18 GMT

You can use

Store <filename> into <filename.ext> (txt, delimiter ' \t ') for a csv file with TAB delimiter .

regards

Rajdeep

Export from Script into Tab delimited file?

Fri, 04 Jun 2010 18:33:58 GMT

Rajdeep,

Is there a way to Store the text file without the header line?

Using a buttom I can do it, but I need to do it at the script level, without user action. Any idea?

A consultant told me to use a macro to remove the first line after my text files are created using Store. I don't know if I can do it in a different way.

Tks,

Marcelo

Export from Script into Tab delimited file?

Tue, 28 Sep 2010 08:57:21 GMT

Actually script command is:

Store <filename> into <filename.ext> (txt, delimiter is '\t');

🙂

AW:Export from Script into Tab delimited file?

Wed, 07 Dec 2011 10:29:33 GMT

Hi,

Did you know you can also export to csv? Simply right click on the object and instead of selecting Send to Excel, select Export. This exports to csv which allows you to download more data and it's much quicker.

Matt

Re: Export from Script into Tab delimited file?

itec_pao — Fri, 23 Feb 2018 12:10:14 GMT

Hi all,

The solution would be:

STORE Table INTO ..\60_Datasource\OMP\GDMProduct.txt (delimiter is \t);

Regards,

Oktay

Re: Export from Script into Tab delimited file?

Tim_Benoit — Mon, 31 Aug 2020 18:55:12 GMT

If you get a syntax error try adding the word "is" like this (txt, delimiter is '\t');