topic Re: Continue load script after Binary Load in QlikView

Continue load script after Binary Load

Tue, 10 Sep 2013 07:38:03 GMT

I am having this problem. I am developing an application where I don’t have access to the business system that the application is connected to. I have created a script to load an excel file that i want to test so that it is working as designed. The excel file is dependent on tables that it loaded previously in the script so I can’t just run a load for the excel script.

I thought that it would be possible to make a binary load first and then run the import of the excel file. But the load script seem to stop after the reload the excel file is not being imported and I get no error messages, Does someone know how to write to have the load script continue after the binary load?

Thanks for any help.

//Fredrik

Re: Continue load script after Binary Load

tresB — Tue, 10 Sep 2013 07:44:37 GMT

If your binary load statement is place at the very first line of the script, there should not be an issue. What is the error you are getting?

Re: Continue load script after Binary Load

Tue, 10 Sep 2013 07:54:33 GMT

I am not getting any error messages but not getting any updated date. It is making the Binary load then not going through the lines I want to test. It is not making that extra import of the excel file only importing the data through the binary load.

Re: Continue load script after Binary Load

tresB — Tue, 10 Sep 2013 07:59:06 GMT

Have you tried debugging the script? (Edit Script->next to 'reload' button)

Re: Continue load script after Binary Load

Tue, 10 Sep 2013 08:11:02 GMT

Yes it stands that it gives null values where there is a connection to the excel file.

Re: Continue load script after Binary Load

tresB — Tue, 10 Sep 2013 08:16:31 GMT

Try to refer to a new excel and reload with dummy data. Then you could come to a conclusion if the excel itself is the issue.

Re: Continue load script after Binary Load

Tue, 10 Sep 2013 08:29:25 GMT

It is not the excel that is the issue. If I try to load it without the binary load it is loading fine until I come to the tables that are dependent on tables that I want to have access to through the Binary load.

Re: Continue load script after Binary Load

stevedark — Sat, 05 Apr 2014 22:50:54 GMT

When you say it stops, does the script complete cleanly or does it stall?

If there is a large synthetic key created by loading the Excel file in after the binary load then this can cause QlikView to get upset and stall without giving an error message.

Ensure that you don't have a table in the QVW you are doing the binary load from that is very similar to the structure of the Excel file.

If you are intending the Excel file to append to the end of an existing table in the data model make sure you use the CONCATENATE statement.

Hope that helps.

Steve