Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am Trying to link 2 tables to a Master calendar, "Team" field is common between two tables and each table has dates which i want to link to calendar, when i try to link it its giving Synthetic keys,
and even when i create a link table, linkages is not working, can any one help me to solve this.
Thanks in advance,
Arjin.
Hi Arjin,
Maybe you can try to rename "team" and link only for date.
Regards
Miguel del Valle de Gracia
Hi Arjin,
Try with a link table, to avoid circular references.
Productivity:
Autonumberhash128(Team&'-'&Calendar_Key) as Prod_Key,
Prod date,
Process type,
...
FROM...
Leaps_Master:
Autonumberhash128(Team&'-'&Calendar_Key) as Leaps_Key,
Case_num,
...
FROM...
LynkTable:
LOAD
Autonumberhash128(Team&'-'&Calendar_Key) as Prod_Key,
Autonumberhash128(Team&'-'&Calendar_Key) as Leaps_Key,
Calendar_Key
RESIDENT
Productivity;
LynkTable:
LOAD
Autonumberhash128(Team&'-'&Calendar_Key) as Prod_Key,
Autonumberhash128(Team&'-'&Calendar_Key) as Leaps_Key,
Calendar_Key
RESIDENT
Leaps_Master;
Load now your master calendar.
Regards!!