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

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

Files:

The same question

Comments (4)

Simon ● 21 months ago

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

Reply URL

Nhi Tran ● 21 months ago

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

Reply URL

Simon ● 21 months ago

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

Reply URL

Nhi Tran ● 21 months ago

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

Reply URL