Discussion Board for collaboration on QlikView Scripting.
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:
Data from table A would be displayed here.
Data from table B should be displayed here.
There is no relation between Table A and Table B. Also, there should be a space between data from Table A and Heading2.
Go to Solution.
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 :
from table A;
'' as col1
'' as col2
col3 as col1,
col4 as col2
from table B;
Store FileToExport into MyFile.txt (txt);
hope this helps.