Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
My data model as below , i want to remove $syn key. can some one
show me.
Hi All
Enclosed my sample QV Doc.
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
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
Hi
You forgot to put '&'
AutoNumberHash128(@50:60T,'TDSS') &' - '& @50:60T as Link_Supply_key_ ,
BR
Ariel
Try this.
eg:
Table1:
date&'-'&LINK_SUPPLY_KEY AS Key,
Table 2:
date,
date&'-'&LINK_SUPPLY_KEY AS Key
Thanks
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.
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
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
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