topic Re: Synthetic Keys while using two or more associated columns for different tables in Connectivity & Data Prep

Synthetic Keys while using two or more associated columns for different tables

Yashwanth_ — Fri, 23 Apr 2021 16:22:45 GMT

Hi,

I am getting synthetic keys as i am having 2 or more similar column names in the different tables . But the tables are associated with 2 columns with joins , how to resolve this ?

Thanks

Re: Synthetic Keys while using two or more associated columns for different tables

rwunderlich — Fri, 23 Apr 2021 22:36:19 GMT

Create a key field by concatenating the two fields into a new field. See

https://qlikviewcookbook.com/resolving-synthetic-keys/

-Rob

Re: Synthetic Keys while using two or more associated columns for different tables

Yashwanth_ — Sat, 24 Apr 2021 05:48:20 GMT

Hi Rwunderlich,

I have requirement that multiple attributes of the table are associated with single attribute of other table , so i renamed by taking duplicate col names and i am unable to create compound or link key by using alias names.

Can you please suggest me an alternate solution for the above scenario.

Thanks

Re: Synthetic Keys while using two or more associated columns for different tables

rwunderlich — Sat, 24 Apr 2021 14:18:08 GMT

What problem are you having creating compound keys? Can you post your script?

-Rob

Re: Synthetic Keys while using two or more associated columns for different tables

Yashwanth_ — Sun, 25 Apr 2021 03:52:41 GMT

Hi,

LOAD

CTRL_ID as %_CTRL_ID
REF_BY_EMP as %_REF_BY_EMP,
REF_ID as %_REF_ID,
REF_TO_EMP as %_REF_TO_EMP

from (some qvd)

LOAD
EMPE_ID as %_EMPE_ID,
EMPE_ID as %_REF_BY_EMP,
EMPE_ID as %_REF_TO_EMP,
EMPE_NM,
EMPE_NO
FROM [*****.qvd] (qvd);

from the 1st script ref_by_emp is associated with empe_id in the 2nd script & similarly ref_to _emp also.

Now when i load the data sythetic keys are coming. Can u help me with this

-Thanks Yashwanth.