topic Re: Loading after Binary Load in QlikView

Loading after Binary Load

Mon, 24 Jul 2017 05:08:05 GMT

Hi,

I have done the binary load successfully and got the data model. I get my data from SQL server database.

After the binary load, I have connected to the database but my tables are not getting updated with the current data.

What else should I do?

Re: Loading after Binary Load

arvind_patil — Mon, 24 Jul 2017 05:17:52 GMT

Hi Julia,

You Need to update data in binary loaded qvw . Means suppose you have Script like below.

Binary D:\Qlikview Function\LiveDataBase.qvw;

So you Need to update into LiveDataBase.qvw

Thanks,

Arvind Patil

Re: Loading after Binary Load

techvarun — Mon, 24 Jul 2017 05:22:47 GMT

The Binary table is the data source for your app always.

so First refresh the data on the data source qlikview application then load the binary loaded one.

Re: Loading after Binary Load

Mon, 24 Jul 2017 05:27:50 GMT

Thanks for your replies.

But I am unable to open the original application, that's why I went for the binary load. Is there any other way to update the file?

Re: Loading after Binary Load

techvarun — Mon, 24 Jul 2017 05:31:43 GMT

Hi In this case

drop the table after binary load
establish the connection to the SQL
reload the table.

In case you have only one table loaded from binary load, The binary load is no more usable.
if you have a last updated datetime field or sequence number available in the table then you can go for the binary load.

Re: Loading after Binary Load

arvind_patil — Mon, 24 Jul 2017 05:53:16 GMT

Hi Julia,

Please try to load all files From QMC.

Thanks,

Arvind Patil