Can I join a virtual table with another virtual table in my yellowfin view?

Nhi Tran shared this question 11 months ago
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

Comments (4)

photo
1

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

photo
1

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

photo
1

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

photo
1

Yes, please mark this ticket as resolved. Thanks again!