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

"Scripting Execution Progress" screen hangs

Hi All,

I tried to upload two comparatively large excel files into Excel files and when I run the script the "script execution" window just freezes.

Pl remember that -

1) all the columns are exactly same in the two excel files

2) all the lines are fetched.QV script box.png

Pl refer the screenshot attached.

Br,

KG

3 Replies
chiru_thota
Valued Contributor

Re: "Scripting Execution Progress" screen hangs

I guess Qlikview is trying to create synthetic table and talking lot of your system resources as there so many columns between two tables.

Why don't you try Concatenate ? it will solve this issue.

Ex :

Tab1:

Load * from Exce1;

Concatenate

Load * from Excel2;

michael_gardner
Contributor III

Re: "Scripting Execution Progress" screen hangs

Is the excel file open when you run the QlikView load? Try to save the excel file and close it.  Also restart your computer and only open QlikView and run it again.

MVP & Luminary
MVP & Luminary

Re: "Scripting Execution Progress" screen hangs

If the number of columns isn't the same or the names of the fields are not exactly the same then Qlikview will create two tables and create a synthetic key using all the fields that are the same. Keep in mind that Qlikview is case sensitive. That means the MyField and Myfield are two different fields to Qlikview. There's a good chance that the names of the fields of your two excel files are not completely the same. That's something you could check. And if necessary rename fields in the script using the as keyword (i.e. Myfield as MyField).


talk is cheap, supply exceeds demand