Executing script takes to long

[#1]

Hello community,

I have a problem. I am reading from 4 different QVDs 3-4 millions in each QVD. Qlikview is performing joins and creating synthetic keys. It takes far to long to execute the script over 15minutes creating 10+ synthetic keys. I dont think it should take this long. Is there anyway to speed up the process? It's currently QVD absed on Year, I need it this way.

Meddelandet redigerades av: Niklas Söderqvist

[PrashantSangle]

Remove synthetic key 10+ are too much for 3-4 million records.

Regards

[Peter_Cammaert]

There is a very easy technique to shorten the delay to reload your documents: eliminate the synthetic keys. If you scan the tilmestamps in the log and compare them with the actual run time, you will see that creating synthetic keys for milliions of rows will take an inordinate amount of time. That time is wasted.

Best,

Peter

[#4]

Yeah, How do I remove them, and how would I perform joins in the app?

[PrashantSangle]

Hi,

Read article about link table, Composite key

Give you better idea about solution.

Regards

[Peter_Cammaert]

Synthetic keys can be easily removed by creating so-called "composite keys". Concatenate all key values into a single field in both tables (and rename/remove the originals) will reduce the association values between tables to a single one in each case. The synthetic keys will go away.

Peter

[PrashantSangle]

or you can post your script.

then we can help to optimize it.

Regards

[#8]

I posted it, in the main. This will be very useful for me if you can help em with this issue.

[PrashantSangle]

Hi,

I am working on personal edition so it will be better for me if you copy and paste your entire script in one doc and attached doc here.

or you can paste your script here.

Regards

[#10]

Hi,

For removing synthetic keys, see below links.

http://www.analyticsvidhya.com/blog/2014/12/remove-synthetic-key-concatenation-link-table-qlikview/

http://www.learnallbi.com/qlikview-resolving-synthetic-keys/

https://community.qlik.com/thread/27662

http://www.learnallbi.com/link-table-in-qlikview/

-Joyson G