topic Re: Writing data to a text file in QlikView

Writing data to a text file

Tue, 26 May 2015 10:38:44 GMT

Hi All,

I have two separate tables created in the backend.

Table A and Table B.

I want to store the data present in these two tables in a single text file.

The text file should contain data in the below format:

Heading1

Data from table A would be displayed here.

Heading2

Data from table B should be displayed here.

Note:

There is no relation between Table A and Table B. Also, there should be a space between data from Table A and Heading2.

Thanks,

Asma

jchoucq — Tue, 26 May 2015 10:45:19 GMT

Dear Asma,

in qlikview, in a store statement, it is one qlikview table into one file.

So you will have to concatenate your table before using the store statement.

your table must have the same name colums, for example :

FileToExport:

Load

col1,

col2

from table A;

Concatenate (FileToExport)

Load

'' as col1

'' as col2

autogenerate (1);

Concatenate (FileToExport)

Load

col3 as col1,

col4 as col2

from table B;

Store FileToExport into MyFile.txt (txt);

hope this helps.

Johann