topic How to store table data into a text .TXT file using the script? in QlikView

How to store table data into a text .TXT file using the script?

mwallman — Fri, 15 Apr 2016 14:22:36 GMT

Hi all,

How do you store table data into a text .TXT file using the script?

I am aware of Store statement but reading about states it only does qvd and csv files?

I would like to store the data in a text file including the headers.

Anyone know how please?

sunny_talwar — Fri, 15 Apr 2016 14:24:03 GMT

Try this:

STORE TableName into File.txt (txt);

awhitfield — Fri, 15 Apr 2016 14:30:42 GMT

Or even better:

STORE TableName into File.txt (txt);

sunny_talwar — Fri, 15 Apr 2016 14:34:30 GMT

100% much better

UPDATE: Not anymore though

asgardd2 — Fri, 15 Apr 2016 14:37:31 GMT

Also, you can add custom delimiter, like this:

STORE Transactions into Transactions.txt (txt, delimiter is '|');