Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Loading after Binary Load

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?

5 Replies
arvind_patil
Valued Contributor III

Re: Loading after Binary Load

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

techvarun
Valued Contributor II

Re: Loading after Binary Load

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.

sample.PNG

Not applicable

Re: Loading after Binary Load

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?

techvarun
Valued Contributor II

Re: Loading after Binary Load

Hi In this case


  1. drop the table after binary load
  2. establish the connection to the SQL
  3. 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.

arvind_patil
Valued Contributor III

Re: Loading after Binary Load

Hi Julia,

Please try to load all files From QMC.

Thanks,

Arvind Patil

Community Browser