Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
vanderson009
Creator III
Creator III

Synthetic Key

Hello Community,

How to identified which method is best to remove synthetic key, concatenate or link table??

Thanks and Regards,

Villyee Anderson.

4 Replies
MK_QSL
MVP
MVP

Depends on your database....

Provide some sample data for your database... Mostly developers using Concatenate most...

amit_saini
Master III
Master III

Villyee,

Follow this:

Miguel_Angel_Baeyens

Hi,

If the synthetic key is happening because two or more fields are named alike in two or more tables, the most sensible way of making sure that you are loading the data as you want is to delete those fields repeated (for example, date in header and line, and you only need one). Another option if you are developing and not sure how to associate tables is renaming fields using AS in the script:

LOAD Field AS Field.1

FROM ...

Once you are sure about how you want to associate your model, then you can decide to JOIN, CONCATENATE, KEEP, etc.

Miguel

vanderson009
Creator III
Creator III
Author

Hi Manish,

This is interview point of question

-- Thanks

Villyee