Possible to Remove $Syn Key

[paulyeo11]

Hi All

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

show me.

[paulyeo11]

Hi All

Enclosed my sample QV Doc.

[ariel_klien]

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...

BR

Ariel

[paulyeo11]

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

[ariel_klien]

Hi

You forgot to put '&'

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

BR

Ariel

[narender123]

Try this.

eg:

Table1:

date&'-'&LINK_SUPPLY_KEY AS Key, 

Table 2:

date,

date&'-'&LINK_SUPPLY_KEY AS Key

Thanks

[paulyeo11]

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.

[#8]

hi

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

[narender123]

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

[#10]

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