topic Re: Avoid Synthetic Keys using Join in QlikView

Avoid Synthetic Keys using Join

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Avoid Synthetic Keys using Join

neelamsaroha157 — Tue, 03 Jul 2018 15:59:09 GMT

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

Re: Avoid Synthetic Keys using Join

Anonymous — Tue, 03 Jul 2018 16:14:29 GMT

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

Re: Avoid Synthetic Keys using Join

neelamsaroha157 — Tue, 03 Jul 2018 16:18:52 GMT

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.