Qlik Community

QlikView Integration

Discussion Board for collaboration on QlikView Integration.

Announcements
Register for Events and Webinars directly from Qlik Community: http://bit.ly/2Vpnenx
Highlighted
Not applicable

Avoiding Circular Joins

If multiple columns from different tables are having the same name, does Qlikview automatically join them? If yes, how does it take care of circular joins etc. ?

Tags (1)
5 Replies
Highlighted
Partner
Partner

Re: Avoiding Circular Joins

This is true. Qlikview links tables on similar field names. If there is a circular loop the largest table will be loosely coupled. This is not recommended.

Highlighted
chiru_thota
Valued Contributor

Re: Avoiding Circular Joins

Yes.But if you have more than one common column Qlikview  will generate synthetic tables.

this is fine until unless you have any issue interns of performance or understanding of data model.

Because of synthetic keys you never get wrong data.

chiru_thota
Valued Contributor

Re: Avoiding Circular Joins

use below url in the attached txt file to understand circular reference and how it is different from synthetic keys.

Circular reference will give wrong data if data is coming from loosely coupled tables.

also have look at below ppt.it is really helpful.

Data Modeling issues and solutions

Highlighted
Not applicable

Re: Avoiding Circular Joins

Thank you for your prompt responses.