
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Link table with circular loops
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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hello!
Use Left Join in the script for joining SpendCoverRecipient table to CoverRecipient table on CoverRecipientId field and make sure on checksums. Should help.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
And rename SpendId field.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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?


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
CoverRecipientID seems more granular than CoverRecipientCatcode. could you try bringing CoverRecipientID to your link table
