Linking multiple tables to master calender

[Anonymous]

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.

[migueldelval]

Hi Arjin,

Maybe you can try to rename "team" and link only for date.

Regards

Miguel del Valle de Gracia

[Anonymous]

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