In my Qlikview Application we have data for returns and we are using Autonumber() to generate keys, we have a huge data and created number of keys.
In addition we have Text data for some fields with two languages, here also i have used Autonumber() to generate keys.
Now i have requirement where i have to join the main table with these Text tables.
Like we have nearly 15 tables to join. Now the problem is if we join these many table to the FinalTable we are facing some performance issues, the reload time is increased and some times the task in QMC is getting failed after loading for hours.
Please Suggest the best way.
In log file i can see the error "Execution cancelled by user" but nobody cancalled the task, It is failing at the time of joining tables with FinalTable.
Ramesh, have a look at the following Design Blog post, may be what you need in this case: