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

Nhi Tran shared this question ago

Completed

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

Replies (5)

Nhi Tran ●

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

Nhi Tran ●

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

Reply URL

Jonathan Culloch ●

Yes, it is possible to join a virtual table to another virtual table in the same Yellowfin View.

Reply URL

Yamini Naidu ●

Hello,

This ticket is now marked as complete. If you need any additional assistance, please feel free to reach out to us; we are here to help.

Regards,

Yamini Naidu

Yellowfin Technical Support

Reply URL

Kurtis Schaden ●

Hi @Poor Bunny

Yes.

You can join two virtual tables in the same Yellowfin View, but there are limitations. Be aware of the common Errors you encounter: Complex SQL or incorrect syntax after the join. Or maybe Duplicate column names or missing aliases.

The solution you can use is Use explicit SQL, column aliases to Avoid JOINing too many virtual tables.

Reply URL