topic Multiple .xls file load locking up and not completing in QlikView

Multiple .xls file load locking up and not completing

Mon, 23 Mar 2015 14:33:46 GMT

Here is the script that I am running. And it seems to load all the records correctly but does not terminate and allow me to access the data. I can run each load instruction separate but not together, what am I missing.

Thanks in advance

SET ThousandSep=',';

SET DecimalSep='.';

SET MoneyThousandSep=',';

SET MoneyDecimalSep='.';

SET MoneyFormat='$#,##0.00;($#,##0.00)';

SET TimeFormat='h:mm:ss TT';

SET DateFormat='M/D/YYYY';

SET TimestampFormat='M/D/YYYY h:mm:ss[.fff] TT';

SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';

SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';

LOAD * FROM

(biff, embedded labels, table is [Consolidated Copy$]);

LOAD * FROM

(biff, embedded labels, table is [Consolidated Copy (2)$]);

Re: Multiple .xls file load locking up and not completing

marcus_sommer — Mon, 23 Mar 2015 16:49:48 GMT

Probably there is more then one common key-field between both tables and qlikview tried to create many synthetic keys which could be to take a long time. You need to rename all common fields which aren't a key or to use a Qualify-Statement:

Synthetic Keys

Circular References

- Marcus

Re: Multiple .xls file load locking up and not completing

Wed, 25 Mar 2015 13:45:08 GMT

Thanks, I took the time to set each field to a unique name and the files are loading.