Circular Reference

[#1]

Hi

Below is my Table Viewer Snapshot.

When i link ALT1 in AMSR_Apr and ALT_DATE in sheet 1 i get a circular Reference.

How do i avoid that

Regards

Senthil

[fvelascog72]

Hi,

In the image I can´t see any circular reference.

[giakoum]

do you mean a synthetic key?

create a composite key with the fields you need to link and drop them from one of the 2 tables

[sunny_talwar]

Why don't you join Sheet1 into the Dept_Master (Script Join) and then I think you will have two tables with two fields they link on. I feel that should help.

Best,

Sunny

[Anonymous]

if you really need to join AltAct1 and Date1

can you rename country_code as country_codeSh column in Sheet table.

and also add one more column in AMSR table  country_code as country_codeSh

AltAct1 as Date . it will create a Sync key but remove Circular reference .

for removing sync key you can concat  fields country_code & AltAct1 as Key2 in both the table.

Now you will not get any sync key not circular ref.

Thanks

BKC

[#6]

Hi

Sheet has got data on a daily basis and Dept Master is a master table, so i think joining is not possible