Can I join a virtual table with another virtual table in my yellowfin view?
Answered
Hi Yellowfin Support,
Is it possible to join a virtual table to another virtual table in the same Yellowfin View? When I complete this join and move onto the next page I get the error attached below.
Thank you
Files:
yellowfin error.PNG
Hi Nhi,
There should be a couple of ways to join Virtual Tables, I think the easiest way would be by defining the join within the SQL statement itself and just have one virtual table. Let me know if this solution works for you.
Kind regards,
Simon
Hi Simon,
Unfortunately I wasn't able to resolve the issue with this method. However, when I changed the direction of the join it seemed to work.
Thanks for helping,
Nhi
Hi Nhi,
I'm glad to hear you managed to figure it out!
Are you happy if I go ahead and mark this as completed, or is there anything else I can help with?
Kind regards,
Simon
Yes, please mark this ticket as resolved. Thanks again!
Comments have been locked on this page!