topic Re: Storing data from multiple tables in a text file in QlikView

Storing data from multiple tables in a text file

Fri, 08 May 2015 09:35:53 GMT

Hi All,

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

Thanks,

Asma

Re: Storing data from multiple tables in a text file

sujeetsingh — Fri, 08 May 2015 09:39:34 GMT

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

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

Re: Storing data from multiple tables in a text file

Gysbert_Wassenaar — Fri, 08 May 2015 09:40:08 GMT

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

Re: Storing data from multiple tables in a text file

Anonymous — Fri, 08 May 2015 09:50:46 GMT

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

Re: Storing data from multiple tables in a text file

petter — Fri, 08 May 2015 18:07:52 GMT

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....