topic Extract large table info into xml, sql or whatever (avoiding using QVD files) in QlikView

Extract large table info into xml, sql or whatever (avoiding using QVD files)

marcel_olmo — Fri, 07 Jan 2011 17:05:44 GMT

Hi guys, I was wondering how can I do it to extract a huge data info from a table into another format that is not QVD.

What I got used to do is to create a table and then "extract it to excel" with the "excel button".

And if I needed to extract it to XML, I do this macro function :

Sub ExtractToXML

set Obj = ActiveDocument.GetSheetObject("TB01")

Obj.ExportXml "C:\Myfolder\MyXmlFile.xml",1200

end Sub

But what about if I the table is not supported by the table itself because of the amount of data?

Is there any easier way to do this?

I insist I need to do it avoiding QVD files, because I need to export the data in another formats.

Many thanks in advance!!

Oleg_Troyansky — Fri, 07 Jan 2011 17:17:24 GMT

SInce version 9.00, you can store tables within a load script into a delimited txt file, using the same command STORE:

STORE MyTable into MyTextFile.txt (txt);

marcel_olmo — Fri, 07 Jan 2011 18:19:48 GMT

Thanks Oleg for your quick reply, I'm interested in extract the table directy into xml or excel if it could be possible.

But by now, if I can store it in a txt file, it's Ok.

Thanks Oleg anyway!!!