Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Avoid Synthetic Keys using Join

Hello

I am creating a report which loads dtaa from two diffent tables, both having  the following fields Institution, and Period, when i do this it creates a synthetic key Syn , Insittution , Period. I remember some time ago, y avoided the creation of Syhn Keys, creating a concatenation of this fields ( someehting like  Institution +'-'+ Period  as InstPer) However if i do this, How can i see infomation by Institution or Period later?

Camilo

3 Replies
neelamsaroha157
Specialist II
Specialist II

Hi Camilo,

Synthetic keys are created when you have same field names in two table.

there are couple of ways to remove the them-

- You will need to rename the fields in both the table and use on of the field in front end for selection.

- As you have only two fields with same name so won't necessarily need Qualify *;

- If both the tables are fact table at same granularity then you can concatenate instead of joining.

Check out this thread for better understanding.

https://community.qlik.com/message/1065803?tstart=0#1065803

Anonymous
Not applicable
Author

Hello Neelam

What i am doing is concatenating them , But then my question is,  how i can use them then ,

I want to show Institution or Period , but those fields donj't exist anymore, but Institution-Period

neelamsaroha157
Specialist II
Specialist II

if you are concatenating two tables then there shouldn't be any Synthetic key. Do mind sharing sample data of may be screen shot of your data model.