Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
camiloflores
New Contributor III

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

Tags (1)
3 Replies
neelamsaroha157
Valued Contributor II

Re: Avoid Synthetic Keys using Join

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

camiloflores
New Contributor III

Re: Avoid Synthetic Keys using Join

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
Valued Contributor II

Re: Avoid Synthetic Keys using Join

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.