Link table with circular loops

[kvr9]

Hi ,

Urgent query ,requesting response asap.

facing circular loop issue with my link table and table .

Below is the screenshot. I dont want to break relation between two tables CoverRecipient and Spend coverrecipent ,but want to relate cover recipientcategory code to link table

[Sergey_Shuklin]

Hello!

Use Left Join in the script for joining SpendCoverRecipient table to CoverRecipient table on CoverRecipientId field and make sure on checksums. Should help.

[Sergey_Shuklin]

And rename SpendId field.

[kvr9]

Hi Shuklin,

I tried to join/Concatenate the tables ,spendid is mandatory field which I cant rename as it is already present in link table.

So now if I join also I need SpndId and coverrecipientcategory code to  link the link table,which again created the sync table.

Could you suggest me how to reslove the issue.

[ieuyar]

I would use a mapping table to avoid such cases and use ApplyMap function to get desired fields.

Is not it appropriate for your data?

[sudeepkm]

CoverRecipientID seems more granular than CoverRecipientCatcode. could you try bringing CoverRecipientID to your link table