topic Re: Possible to Remove $Syn Key in QlikView

Possible to Remove $Syn Key

paulyeo11 — Sun, 21 Jul 2013 07:15:42 GMT

Hi All

My data model as below , i want to remove $syn key. can some one

show me.

Re: Possible to Remove $Syn Key

paulyeo11 — Sun, 21 Jul 2013 07:17:10 GMT

Hi All

Enclosed my sample QV Doc.

Re: Possible to Remove $Syn Key

ariel_klien — Sun, 21 Jul 2013 08:51:34 GMT

Hi,

I can't open your example but you can make the key with the Date inside:

Sales_table:

LOAD date,

Link_Supply_key &' - ' date as Link_Supply_key ,

Report_dod_1,

...

From ....;

Supplier:

LOAD:

Link_Supply_key &' - ' date as Link_Supply_key ,

...

//(without the column date)

From .....;

LinkTable:

LOAD:

Link_Supply_key &' - ' date as Link_Supply_key ,

...

//(without the column date)

From .....;

something like this.

Disadvantage : if you don't have a date in Sales_table and you have the date in other table the calendar will not filtered him.

Hope this will help you...

Ariel

Re: Possible to Remove $Syn Key

paulyeo11 — Mon, 22 Jul 2013 03:53:31 GMT

Hi Ariel

i see your reply , thank you very much. i try below , i get error :-

my 2 field as below :-

AutoNumberHash128(@50:60T,'TDSS') As Link_Supply_Key,

@50:60T as [date]

i create a new field :-

AutoNumberHash128(@50:60T,'TDSS') &' - ' @50:60T as Link_Supply_key_ ,

I get error.

any advise ?

Paul

Re: Possible to Remove $Syn Key

ariel_klien — Mon, 22 Jul 2013 05:22:49 GMT

You forgot to put '&'

AutoNumberHash128(@50:60T,'TDSS') &' - '& @50:60T as Link_Supply_key_ ,

Ariel

Re: Possible to Remove $Syn Key

narender123 — Mon, 22 Jul 2013 05:50:38 GMT

Try this.

eg:

Table1:

date&'-'&LINK_SUPPLY_KEY AS Key,

Table 2:

date,

date&'-'&LINK_SUPPLY_KEY AS Key

Thanks

Re: Possible to Remove $Syn Key

paulyeo11 — Thu, 25 Jul 2013 03:20:18 GMT

Hi Narender

I try your approach , but still not able to get it right after twice attemp.

can you help me with my enclosed script ?

as it is very confuse.

Re: Possible to Remove $Syn Key

Thu, 25 Jul 2013 05:03:34 GMT

when two or more than two fields are common between two tables the synthetic key made.

for remove synthetic key there are following ways--

1- change the alies name that is chage the field name

2-- concatenate the both table in which the more than one fields common

3-- join the both table in which the more than one fields common

4-- making composite key if two fields are same in both table

composite key made by using field1 & field2 as compositekey in both table

also by using Autonumberhash(field1,field2) as key

hope by the use of these you can solve the problem of synthetic key

Regards

vishwaranjan

Re: Possible to Remove $Syn Key

narender123 — Thu, 25 Jul 2013 05:08:47 GMT

Hi,

I have done some changes for avoid Syn key.

As i did not have your table data, so only thing that i done in your script is in attached qvw.

Please see the concept that written in attached qvw script.

Thanks

Re: Possible to Remove $Syn Key

Thu, 25 Jul 2013 05:09:22 GMT

HI,

To remove synthetic Key plz rename the field which forms a synthetic key or use qualified and unqualified infront of load statement this is a simple idea i hope this may helpfull to you

Re: Possible to Remove $Syn Key

Thu, 25 Jul 2013 05:11:00 GMT

HI,

To remove synthetic Key plz rename the field which forms a synthetic key or use qualified and unqualified infront of load statement this is a simple idea i hope this may helpfull to you

Re: Possible to Remove $Syn Key

Thu, 25 Jul 2013 05:41:40 GMT

hi..

Try qualify before a table name.

Eg :

qualify

tablename :

Load a,

from

somewhere;

Re: Possible to Remove $Syn Key

paulyeo11 — Thu, 25 Jul 2013 07:02:27 GMT

Hi Vish

many thank from your detail step .

as programmer need to step by step cannot rush thru.

so programmer job need to have passion.

and must be able to work under stress ..

Paul

Re: Possible to Remove $Syn Key

paulyeo11 — Thu, 25 Jul 2013 15:21:42 GMT

Hi Sath

I try as qualify before the table name , the qualify wording is bluw color , and when i run i get error msg.

Paul

Re: Possible to Remove $Syn Key

paulyeo11 — Thu, 25 Jul 2013 15:26:08 GMT

Hi Amu

i try your advise , i am not able to type qualify or qualified , this word is not understand by QV.

Re: Possible to Remove $Syn Key

paulyeo11 — Thu, 25 Jul 2013 15:28:33 GMT

Hi Nar

i try to understand your script , and iunable to clear the error , i notice you try to load the same table again. any reasons ?

Re: Possible to Remove $Syn Key

paulyeo11 — Thu, 25 Jul 2013 15:29:38 GMT

Hi Ariel

Thank you very much , it work after i add & into my expression.

But sync key still there .

Paul

Re: Possible to Remove $Syn Key

nizamsha — Thu, 25 Jul 2013 15:41:49 GMT

easy way to remove synthetic key is ..rename the unwanted fieldname in the table...the field name showing synthetic key

Re: Possible to Remove $Syn Key

paulyeo11 — Sun, 28 Jul 2013 21:05:10 GMT

you are right , see the below link , it work like what you said.

http://community.qlik.com/message/373153#373153