topic Re: "Scripting Execution Progress" screen hangs in QlikView

"Scripting Execution Progress" screen hangs

Sat, 29 Mar 2014 15:39:25 GMT

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.

Pl refer the screenshot attached.

Br,

Re: "Scripting Execution Progress" screen hangs

chiru_thota — Sat, 29 Mar 2014 15:53:24 GMT

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;

Re: "Scripting Execution Progress" screen hangs

Anonymous — Sat, 29 Mar 2014 16:18:56 GMT

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.

Re: "Scripting Execution Progress" screen hangs

Gysbert_Wassenaar — Sat, 29 Mar 2014 16:48:12 GMT

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).