Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
datalakeyu
Not applicable

How to solve synthetic key in Qlik sense?

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!

1 Solution

Accepted Solutions
dixit_panchal1
Not applicable

Re: How to solve synthetic key in Qlik sense?

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

7 Replies
zfonline7888
Not applicable

Re: How to solve synthetic key in Qlik sense?

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

eduardo_sommer
Not applicable

Re: How to solve synthetic key in Qlik sense?

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
Not applicable

Re: How to solve synthetic key in Qlik sense?

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
Not applicable

Re: How to solve synthetic key in Qlik sense?

Not applicable

Re: How to solve synthetic key in Qlik sense?

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.

dixit_panchal1
Not applicable

Re: How to solve synthetic key in Qlik sense?

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

singhpooja
Not applicable

Re: How to solve synthetic key in Qlik sense?

Hi Haikup,

You can use qualify function.

Thnaks,