topic Export to TXT without headers in QlikView

Export to TXT without headers

Mon, 21 Jun 2010 09:25:19 GMT

Created a macro to export a SheetObject to txt/csv. I would like to export the object without headerrow. Any suggestions on how i could change the Macro to do so?

Current Macro looks like this:

Sub

set

sObject = ActiveDocument.GetSheetObject("CH67") SR39

sObject.Export

\\filename.txt",";"

End

Sub

Export to TXT without headers

hectorgarcia — Tue, 09 Nov 2010 14:09:13 GMT

i am also interested in this solution, many customers define flat files atructured with no headers...

Hector

Export to TXT without headers

Wed, 10 Nov 2010 10:08:47 GMT

There is a very simple workaround: cut the headers from the file after the export. For example file data.txt like this :

Product,Region,Value
one,a,234
one,b,54
one,c,54
three,a,635
three,b,891

Have a batch file containing

type data.txt | find /V "Product,Region,Value" > noheader.txt

-Alex