topic Re: How to remove synthetic key? in QlikView

How to remove synthetic key?

Thu, 11 Sep 2014 10:43:27 GMT

Hi,

I have a below script in qvw. when I am reloading it is forming synthetic key on ID and Com1. How can I remove the synthetic key. can anyone please help me in this.

Paper:
LOAD ID,
     Paper,
     [Paper Name],
     name,
     Com1,
     Com2,
     Com3,
     Com4
FROM
Paper.qvd
(qvd);

SR:
LOAD RowNo as Row,
     Id       as ID,
     Comad1   as Com1,
     Comad2,
     Comad3,
     Comad4

FROM
SR.xlsx
(ooxml, embedded labels, table is SR);

Thanks.

Re: How to remove synthetic key?

senpradip007 — Thu, 11 Sep 2014 10:48:18 GMT

Just rename one of your column name either of the tables. If you want to make a link with both ID & Com1 then you can make a composite key with ID and Com1.

Re: How to remove synthetic key?

ashfaq_haseeb — Thu, 11 Sep 2014 10:48:48 GMT

Try this

Paper:

LOAD ID,

ID&Com1 as Key,

Paper,

[Paper Name],

name,

Com1,

Com2,

Com3,

Com4

FROM

Paper.qvd

(qvd);

SR:

LOAD RowNo as Row,

Id,

Comad1,

Id&Comad1 as Key,

Comad2,

Comad3,

Comad4

FROM

SR.xlsx

(ooxml, embedded labels, table is SR);

Regards

ASHFAQ

Re: How to remove synthetic key?

MarcoWedel — Thu, 11 Sep 2014 10:49:17 GMT

Paper:
LOAD ID,
     Paper,
     [Paper Name],
     name,
     Com1,

     AutonumberHash128(ID, Com1) as Key,
     Com2,
     Com3,
     Com4
FROM
Paper.qvd
(qvd);

SR:
LOAD RowNo as Row,
Id,
Comad1,

     AutonumberHash128(Id, Comad1) as Key,
     Comad2,
     Comad3,
     Comad4

FROM
SR.xlsx
(ooxml, embedded labels, table is SR);

Re: How to remove synthetic key?

Anonymous — Thu, 11 Sep 2014 10:49:46 GMT

you Need to define a new key

ID & Com1 as %Key1

Load ID & Com1 as %Key,

ID as ID1,

Com1 as Com1a,

Com2,

from Paper.qvd

SR:
Load ID & COm1 as &Key,

ID as ID2,

Comad1,

Comad2,

from SR.xlsx

Re: How to remove synthetic key?

Thu, 11 Sep 2014 10:58:59 GMT

Thanks.