How to solve synthetic key in Qlik sense?

[Anonymous]

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!

[zfonline7888]

Try to change the column name to avoid synthetic key, and only load columns needed.  Hope this will be helpful.

[eduardo_sommer]

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

[bill_mtc]

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

[shraddha_g]

Refer Synthetic Keys

What is synthetic keys? How it can be avoided?

https://qlikcommunity.qliktech.com/thread/117476

I hope it Is helpful.

[#6]

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.

[Anonymous · Accepted solution]

For removing Synthetic keys in your Qlik Sense application. These  techniques are:

1. Concatenation
2. Link/ Key Table
3. Using QUALIFY
4. Aliasing
5. Remove Fields

Regards,

Dixit

[Anonymous]

Hi Haikup,

You can use qualify function.

Thnaks,