Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have several tables have same primary keys. Such as table one has Name Number, table two has Name Number date, Table Three has Name Date...Something just like that.
While I run more than 10 tables it seems that QV will combine different PK from tables. But it takes long time to run this step.
What should I add to the script in order to increase speed to run the tables?
Thanks!!
Hi,
I don't know your data model and I don't know how big are the tables, maybe you could concatenate them
It's difficult to answer without knowing your data model but if there are synthetic keys, it will slow down your loading process.
How to write the script for the synthetic keys?
Qlik will join the data using fields with the same name, so make sure it's not creating unecessary synthetic keys. You can use aliases to control what should be the key.