Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Regarding circular loop and Linktable

Hi Friends,

I have three excel data sheets, one is master data sheet it has a field called zone, another two excel data sheet they also contain common field called zone when i tried to link,it creates circular loop, i have  many other data also which has been linked through link table, now i need to link  these three excel data also along with this, i am not getting how to link.

In link table i have common fields of Dealercode  , commonyear , commondate  and not zone.

but these three excel data contains zone as common.

so help me to solve this issue.

Thanx in advance,

NikithaJain

3 Replies
jpapador
Partner - Specialist
Partner - Specialist

A Picture of your table viewer would be helpful but in general when using a link table model.  The table must Either link to the link table or to a dimension table, it cannot link to both.  Without seeing the data structure I'm not real sure what your issue is.

Not applicable
Author

Hi Nikitha,

Can you post snapshot of your data model here.

So that the scenario is much more clear.

Regards,
Snehal Nabar

Not applicable
Author

Nikitha,

Before looking into the actual problem, first take a call if the problem can be resolved using Concatenate.

Creating a Link table is expensive interms of time and involves lot of attention to your script.

In reply to your post, pls check this

http://community.qlik.com/message/313069