Multiple .xls file load locking up and not completing

[#1]

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)$]);

[marcus_sommer]

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

[#3]

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