Possible to Remove $Syn Key

[paulyeo11]

Hi All

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

show me.

[#2]

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

[#3]

hi..

Try qualify before a table name.

Eg :

qualify

tablename :

Load a,

b

from

somewhere;

[paulyeo11]

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

[paulyeo11]

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

[paulyeo11]

Hi Amu

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

[paulyeo11]

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 ?

[paulyeo11]

Hi Ariel

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

But sync key still there .

Paul

[nizamsha]

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

[paulyeo11]

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

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