topic Resolve synthetic key in QlikView

Resolve synthetic key

Anonymous — Thu, 31 Mar 2016 05:10:16 GMT

Hi all,

I have got two tables.

Source and Target.

Source got cust_ID, Semester,Area

Target got cust_ID, Semester, Year, Month,Country

I want these cust_ID and Semester to be linked together.

Here in this case, it forms a synthetic key, if i change the Semester field name with alias name then the relation between tables are broken.

How can i get these two fields to be linked between two tables without forming synthetic key

Re: Resolve synthetic key

Kushal_Chawda — Thu, 31 Mar 2016 10:20:16 GMT

Create the Key using Cust_ID & semester

Table1:

LOAD cust_ID as CustID_1,

Semester as Semester_1,

autonumber(cust_ID&Semester) as Key

Area

FROM table1

Table2:

LOAD

autonumber(cust_OD&Semester) as Key

cust_OD,

Semester,

Year,

Month,

Country

FROM table2

Re: Resolve synthetic key

Chanty4u — Thu, 31 Mar 2016 10:20:57 GMT

use concatenated key

load *,

Cust_Id '&_&' Semester as newId

Re: Resolve synthetic key

arasantorule — Thu, 31 Mar 2016 10:29:16 GMT

Hi,

Can you try the below

Table1:

LOAD cust_ID,

Semester,

cust_ID&Semester as Key,

Area

FROM [...\xyz];

Table2:

LOAD

cust_OD&Semester as Key,

Year,

Month,

Country

FROM [...\xyz];

Thank You

Re: Resolve synthetic key

Anonymous — Fri, 01 Apr 2016 07:03:57 GMT

thanks all for your suggestions and answers, i got the solution

Re: Resolve synthetic key

Chanty4u — Fri, 01 Apr 2016 08:11:26 GMT

coooooooool