topic Re: script running block when creating Sync in QlikView

script running block when creating Sync

Thu, 26 Jun 2014 08:51:18 GMT

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

Re: script running block when creating Sync

tresB — Thu, 26 Jun 2014 09:09:01 GMT

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;

Re: script running block when creating Sync

Thu, 26 Jun 2014 11:09:56 GMT

OK thanks.

it seems to work