topic Re: synthetic key in QlikView

synthetic key

ssriramin19 — Tue, 09 Apr 2013 06:12:31 GMT

Hi,

I have two tables A and table B. There are over 100 columns in table A and table B. The column names in table A and table B is same. So synthetic key is formed.How to remove the synthetic key in this case?

Can anyone help me in avoiding the synthetic key ?

Thanks

Sriram

Re: synthetic key

Mon, 27 May 2013 06:24:48 GMT

hi,

you need to rename the columns of either of the tables so that except for the primary key, none of the columns have same names.

rgds,

mrunmayi

Re: synthetic key

er_mohit — Mon, 27 May 2013 06:31:21 GMT

Try this

Doing Join between two tables

hope it helps

Re: synthetic key

Mon, 27 May 2013 06:31:55 GMT

Hi ,

Try to use Qualify Keyword.

Qualify * ;

UnQualify primaryField Name ;

Regards

Yusuf

Re: synthetic key

sivarajs — Mon, 27 May 2013 06:48:25 GMT

Just do a concatenation between the tables

Re: synthetic key

Mon, 27 May 2013 06:53:10 GMT

You can remove synthetic key by the following ways.

1. using JOIN between two table

2. using CONCATENATE between two table

3. rename fieldnale in both table except primary key

4. using Qualify