topic TableBox as source for replace load? in QlikView

TableBox as source for replace load?

Mon, 12 Mar 2012 16:37:49 GMT

Hi,

can I do a partial reload from the current selection of a TableBox into the same qvw where the table box resides?

The data of the tablebox shall be an additional table in my DataModel.

regards

Eckhard

TableBox as source for replace load?

pover — Mon, 12 Mar 2012 16:57:05 GMT

No. You could however export the values in your tablebox to a QVD file and import that in as a partial reload. The QVD export and reload can be done manually or using a macro. There are examples of the exporting using macros in QlikCommunity, or you can look in the APIGuide.qvw.

Karl

TableBox as source for replace load?

Mon, 12 Mar 2012 17:16:07 GMT

Hi Karl,

thanks for your quick reply. I already work with (append)export to a file. Output is a txt. How can I force qvd to be output?

tks Eckhard

TableBox as source for replace load?

pover — Mon, 12 Mar 2012 17:54:50 GMT

If you're doing the export by macro then you should have a parameter the determines the file type you are exporting. If you are already using txt then work with that. I've seen problems with exporting to QVD using a macro in version 10.

I usually export the txt files to a certain folder and then within the script I reload all the txt files in the folder, add the new data to the existing data, save all the data to a qvd file, and then in the script delete the txt files from the folder.

Karl

TableBox as source for replace load?

Wed, 14 Mar 2012 13:39:34 GMT

Hi, while ExportEx can't create native qvd, I stay with txt format.

Thanks for help. Eckhard