Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
In the data model, there are several tables with the same column name.
When the data was loaded into Qlik sense, there is synthetic key.
As there are several columns, it has to use several atlas.
Is there any other good method or walkaround to solve synthetic key?
Thanks!
For removing Synthetic keys in your Qlik Sense application. These techniques are:
Regards,
Dixit
Try to change the column name to avoid synthetic key, and only load columns needed. Hope this will be helpful.
Hi,
As you said you have several columns with the same name, you probably are dealing with similar information. So, you can concatenate the several tables and, you can create an extra field that can identify the source or kind of information. All columns will then be stored in one single table in qlik sense. Those columns that are not present in certain source table wil receive a null.
Hope this helped you
Eduardo
Hi Haikuo,
The only solution you could impose is to remove the columns/fields exist in the other table. But prior removing them, make sure they were not necessary already, since they already existed in the other table.. and yet we are talking same data.
In any case that the same columns/fields were not related, then this is the time that you should utilize alias or 'AS' in renaming the fields.
Hope it helps!
Regards,
Bill
Refer Synthetic Keys
What is synthetic keys? How it can be avoided?
https://qlikcommunity.qliktech.com/thread/117476
I hope it Is helpful.
Hi Haikuo,
Ways to get rid of Synthetic Keys:
1. Using QUALIFY
This enforces QlikView to qualify all/selected fields.
2. Aliasing
If you alias the conflicting fields.
3. Remove unnecessary Fields.
4. Auto number
If you need to concat the Syn Key candidate fields and create your own key,
you can use Auto-number/Autonumberhash128/Autonumberhash256 function.
This will create a unique integer value for each distinct combination of the concatenated columns.
For removing Synthetic keys in your Qlik Sense application. These techniques are:
Regards,
Dixit
Hi Haikup,
You can use qualify function.
Thnaks,