Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Continue load script after Binary Load

Hi

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

7 Replies
tresesco
Not applicable

Re: Continue load script after Binary Load

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?

Not applicable

Re: Continue load script after Binary Load

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.

tresesco
Not applicable

Re: Continue load script after Binary Load

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

Not applicable

Re: Continue load script after Binary Load

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

tresesco
Not applicable

Re: Continue load script after Binary Load

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.

Not applicable

Re: Continue load script after Binary Load

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.

stevedark
Not applicable

Re: Continue load script after Binary Load

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