Storing data from multiple tables in a text file

[#1]

Hi All,

Is it possible to store the data from multiple tables in qlikview into a single text file.

Thanks,

Asma

[sujeetsingh]

What information you want to same the table in the qlikview.

You can use table box and export to exel and then save .

[Gysbert_Wassenaar]

Yes, first concatenate the two tables into one table and then store the resulting table in the text file.

[Anonymous]

Yes you can do it...

use it like ::

Table1:

LOAD SicknessMonth ,

     TargetSickness,

     ActualSickness

FROM  ABC;

Concatenate

LOAD SicknessMonth ,

     TargetSickness,

     ActualSickness

FROM  XYZ;

STORE Table1 INTO $(vQVDPath)Tabel.csv(txt);

Thanks

BKC

[petter]

If you accept to have a Macro triggered from a button you could use the ServerSideExportEx method to export to a text-file AND append if you like too.... It has a parameter to specify append explicitly.

Example:

Sub Export

     set tb = ActiveDocument.GetSheetObject("TB01")

     tb.ServerSideExportEx "C:\test.txt" , ";" , 1,1252,-1       '0=HTML, 1=Text, 2=Bitmap, 3=XML, 4=QVD, 5=BIFF

End Sub

     The 1 is for Text

     1252 is the CodePage .... Windows Codepage 1252

     -1 means append, 0 means overwrite or create....