How can i remove circular joins?

Kwethemba Nkabinde shared this question 1 year ago
Answered

Are circular joins supported in yellowfin 7.3 and if they are not how do i get rid of them? "circular joins detected" warning

Comments (3)

photo
1

HI Kwethemba,

No circular joins actually have a patent on them so are not available (though they should not be needed)

The best way to get rid of this is to find it in your view builder (typically you can just move tables around until it becomes obvious), and remove the final join that makes it circular.

For example if you joined the following three tables: A->B->C->A

The final C->A link makes this circular.

Nathan

photo
1

Thank you, I tried this and it worked.

photo
1

Glad to hear it!