How can i create a view to join two tables with different data types?
I'm new to Yellowfin, so kindly bear with me a bit :)
I'm trying to create a view. I have two tables "invoice" and "project".
The invoice table references a project via column "invoice.project" of data type VarChar which actually contains numeric IDs of the related project.
The project table has an ID column of type Integer.
Unfortunately the data types don't match so when I try to create the join condition and I select the join-column on either side, the other side is missing.
How can I apply a text-to-number transformation before creating the view & the joins so that I get identical data types in both tables for the view ?
Thank you & Best Regards