Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

leandro_abad
New Contributor II

Export 2 objects in 1 cvs file with header

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!

Tags (3)
4 Replies
ecolomer
Honored Contributor II

Re: Export 2 objects in 1 cvs file with header

Re: Export 2 objects in 1 cvs file with header

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

leandro_abad
New Contributor II

Re: Export 2 objects in 1 cvs file with header

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

Re: Export 2 objects in 1 cvs file with header

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

Community Browser