topic Re: Synthetic Keys in QlikView

Synthetic Keys

Mon, 09 Mar 2015 09:39:30 GMT

HI,

I have a table contains prjct id,emp id and employee name..etc.. and TABLE 2 with prjct name and employee id

Now i have to link these two tables.based on both project id and EMp id. based on Prjct id it has been linked to other tables .since i need to get the EMployee name in Table 2 i have to link TABLE 1 With TABLE 2.

for some reports to work properly PROJECT ID is also a key between the two.

What can be done..pls suggest..

Re: Synthetic Keys

arulsettu — Mon, 09 Mar 2015 09:43:26 GMT

concatenate both tables

Re: Synthetic Keys

maleksafa — Mon, 09 Mar 2015 09:44:24 GMT

you need to create a concatenate key, for example if you want to link Table 1 and Table 2 based on prjct id and emp id, you need to create a key which is [prjct id] & ' | ' & [emp id] as PrjcEmpID in both tables, you need to have only one link between two tables.

if you post the whole schema it would be easier to tell.

Re: Synthetic Keys

PrashantSangle — Mon, 09 Mar 2015 09:55:32 GMT

Hi,

Use Outer Join

Regards

Re: Synthetic Keys

Mon, 09 Mar 2015 09:56:25 GMT

hi..

thanks for yur reply,..

But the issue is tht ,there are other tables which is linked to both tables based on project id and emp id...

Re: Synthetic Keys

maleksafa — Mon, 09 Mar 2015 10:11:59 GMT

ok then you need to concatenate some tables in your schema, again i cannot tell unless you share all your schema.

Re: Synthetic Keys

mukesh24 — Mon, 09 Mar 2015 10:14:41 GMT

Concatenate both Table