script running block when creating Sync

[#1]

I have 3 different excel tables (more or less 350.000 rows for each table).

When I upload 3/4 of the rows from all the tables (the filter excludes some markets) all the procedure lasts about 20 minutes (upload of the data and creation of the Sync tables.

When I upload all the data the procedure stops always at a specific Sync tables:

• the usage of memory is fixed with no changes
• qlik seems to be active but after hours and hours the procedure is always at the same step

Someone can help?

Thanks

Andrea

[tresesco · Accepted solution]

This could be because your excel tables have many fields in common. This creates synthetic keys and if the number of fields in synthetic keys is too much, the problem is expected. Try to concatenate them all and reload like:

Load * From excel1path;

Concatenate

Load * From excel2path;

Concatenate

Load * From excel3path;

Concatenate

Load * From excel4path;

[#3]

OK thanks.

it seems to work