How can i remove circular joins?
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
Are circular joins supported in yellowfin 7.3 and if they are not how do i get rid of them? "circular joins detected" warning
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
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
Thank you, I tried this and it worked.
Thank you, I tried this and it worked.
Glad to hear it!
Glad to hear it!
Replies have been locked on this page!