topic Re: Link table with circular loops in QlikView

Link table with circular loops

kvr9 — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Link table with circular loops

Sergey_Shuklin — Wed, 01 Nov 2017 09:01:58 GMT

Hello!

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

Re: Link table with circular loops

Sergey_Shuklin — Wed, 01 Nov 2017 09:03:27 GMT

And rename SpendId field.

Re: Link table with circular loops

kvr9 — Wed, 01 Nov 2017 09:13:06 GMT

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.

Re: Link table with circular loops

ieuyar — Wed, 01 Nov 2017 12:19:32 GMT

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?

Re: Link table with circular loops

sudeepkm — Wed, 01 Nov 2017 12:45:40 GMT

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