Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Folks,
While loading the data 6 synthetic keys are formed all the tables which are linked each other are required.
Can some help me how to remove the sys keys without concatenate table
Hi
What you need is link table. Take a look at this blog post:
http://www.qlikfix.com/2016/09/08/elegant-link-table-script/
The synthetic keys are composite keys formed when there are multiple field shared between tables. The resolution is dependant on your data model, so it not possible give a simple solution.
Look to see if the common fields are required in both tables, don't load the fields not required, alias the values or make your own composite keys (for example, by concatenation).
i would avoid simply qualifying the loads without trying to properly understand your data model and the analytical requirements.