topic Re: Export 2 objects in 1 cvs file with header in QlikView

Export 2 objects in 1 cvs file with header

Anonymous — Thu, 11 Sep 2014 14:58:03 GMT

Hi,

To solve my problem I use this code:

function GenerateCSV

Set t1 = ActiveDocument.GetSheetObject("TB01")

t1.Export "tables.csv", ";"

Set t2 = ActiveDocument.GetSheetObject("TB02")

t2.Export "tables.csv", ";",, TRUE

end function

This work fine but the second header is not in the file and I have to have the 2 header in the file.

I am new in Qlikview and I don't know where can I found information about VBScripting for QV.

Thanks!

Re: Export 2 objects in 1 cvs file with header

ecolomer — Thu, 11 Sep 2014 15:02:29 GMT

You can see ...

http://www.qlikblog.at/971/qliktip-32-exporting-multiple-objects-single-excel-document/

Re: Export 2 objects in 1 cvs file with header

marcus_sommer — Thu, 11 Sep 2014 16:10:49 GMT

A very good overview about qlikview-vbs which included the objectmodel, examples and parameters could you find in APIGuide.qvw in our intsall-folder by automation.

If your code worked unless the header from table 2 you could try it with an third export between your tableboxes which only contained the header.

- Marcus

Re: Export 2 objects in 1 cvs file with header

Anonymous — Thu, 11 Sep 2014 16:31:13 GMT

How I export only the header? Is a property of the object (t2)?

Re: Export 2 objects in 1 cvs file with header

marcus_sommer — Thu, 11 Sep 2014 16:36:11 GMT

You could use a textbox or chart-table for this in which you the header from t2 manually creates. This object could also be hidden directly or in a specialized hidden sheet for prints and exports.

- Marcus