Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Writing data to a text file

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

1 Solution

Accepted Solutions
jchoucq
Partner - Creator III
Partner - Creator III

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

View solution in original post

1 Reply
jchoucq
Partner - Creator III
Partner - Creator III

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