Synthetic Keys slows down script execution

[Anonymous]

    Hi everyone!

Im having an issue with synthetic keys causing my script load to take FOREVER and no data actually appears.

I have a code that pulls multiple excel tabs fom multiple excel files. The files I use ar enot large at all, but for some reason Qlikview is giving me a hard time. Can anyone give a suggestion within my code?

For Each file in FileList('LOCATION OF FOLDER HERE\*.xlsx');

ODBC CONNECT32 TO [Excel Files;DBQ=$(file)];

tables:

SQLtables;

DISCONNECT;

FOR i = 0 to NoOfRows('tables')-1

LET sheetName = purgeChar(purgeChar(peek('TABLE_NAME', i, 'tables'), chr(39)), chr(36));

Table:

Load

*

From $(file)(ooxml, embedded labels, table is [$(sheetName)]);

NEXT i

Drop Tables Table;

Next file

[Qrishna]

If you want all the tables with no concatenation, uSe 'Qualify' key before each table load.this ensure you have all the tables without formation of any synthetic keys.

Please post atleast some sample files.

[Anonymous]

I agree with Peter, it's the best solution!

or

qualify / unqualify

or

drop table

or

drop field