Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello I created this data model in my Qlik app and although all the table fields have different names, Qlik still produces a synthetic key. Is that something that I can avoid or should I just leave it as it is? Thanks
Well it is best practice to avoid them, as it can cause the apps to be slow if there is a lot of data.
It will happen when you have the field on multiple tables with the same name, If you share your Data model view from qlik we could probable advise how to fix
Multiple synthetic keys are often an indication of a bad data model. They may be handled gracefully or may require excessive memory and time. Ideally, you should remove all synthetic keys from your script as a best practice.
More here Handling synthetic keys Synthetic keys