Loading after Binary Load

[#1]

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?

[arvind_patil]

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]

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.

[#4]

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]

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]

Hi Julia,

Please try to load all files From QMC.

Thanks,

Arvind Patil