Yellowfin Support Team
Category
Data Sources
Product Version
9.0
Joining Views from different datasources
Completed
I am trying to join two different views from two different datasources (Two Different SQL server Databases)
When ever i try to join them via a subquery in the report creation screen it brings back the values as blank.
The values exist in both tables as i've done this test with a simple ID join of 1-100 on both tables to further test to no avail.
Any pointers ?
The same question
Hi Sofian,
I hope you're doing well and thanks for contacting Yellowfin with your question.
Can I just quickly ask which version of Yellowfin you're running? And are you using the default shipped-with-Yellowfin MSSQL Server driver?
Hi Sofian,
I hope you're doing well and thanks for contacting Yellowfin with your question.
Can I just quickly ask which version of Yellowfin you're running? And are you using the default shipped-with-Yellowfin MSSQL Server driver?
Hi Sofian,
I can confirm this is working in 9.16. I'll need to double check in 9.13 which will take a little longer. Are your two fields using the same underlying datatape, e.g. int4 for 1-100? Are you also using an append left outer join or something else?
Kind regards,
Chris
Hi Sofian,
I can confirm this is working in 9.16. I'll need to double check in 9.13 which will take a little longer. Are your two fields using the same underlying datatape, e.g. int4 for 1-100? Are you also using an append left outer join or something else?
Kind regards,
Chris
Hi Sofian and Chris,
Noticed this question, and my understanding/from experience when subqueries are to a view from a different source it will run the query against the second source's row limit first, then look for joins in that returned data.
Subqueries to the same source are able to find the joins then return the top X results as per the row limit hence those subqueries will be populated as expected. By contrast, if your data matches are not in the top X results of your different source subquery it will then be blank.
You'll need to filter your subquery accordingly to ensure your matches can be returned in those top X results of the second source's row limit so that then they can be matched and joined to your master query.
Happy to be corrected, or ignore if this is not relevant or if your data size is well under your source/view/report row limits!
Thanks,
Brendan
Hi Sofian and Chris,
Noticed this question, and my understanding/from experience when subqueries are to a view from a different source it will run the query against the second source's row limit first, then look for joins in that returned data.
Subqueries to the same source are able to find the joins then return the top X results as per the row limit hence those subqueries will be populated as expected. By contrast, if your data matches are not in the top X results of your different source subquery it will then be blank.
You'll need to filter your subquery accordingly to ensure your matches can be returned in those top X results of the second source's row limit so that then they can be matched and joined to your master query.
Happy to be corrected, or ignore if this is not relevant or if your data size is well under your source/view/report row limits!
Thanks,
Brendan
Hi Brendan,
Many thanks for weighing in!
That might help and it's always good to know more of the many the quirks of subqueries. I'm interested to find out Sofians tables are affected by the row limits in that way. Although, if it's two test tables with only the values 1-100 and it's still not working that could also point to something else.
Kind regards,
Chris
Hi Brendan,
Many thanks for weighing in!
That might help and it's always good to know more of the many the quirks of subqueries. I'm interested to find out Sofians tables are affected by the row limits in that way. Although, if it's two test tables with only the values 1-100 and it's still not working that could also point to something else.
Kind regards,
Chris
Hi Sofian
I hope you're doing well.
Just checking in to see if you still need assistance here, as I haven't heard from you in some time.
Kind regards,
Chris
Hi Sofian
I hope you're doing well.
Just checking in to see if you still need assistance here, as I haven't heard from you in some time.
Kind regards,
Chris
Hi Sofian,
I hope all is well,
Mark here from the EMEA Support Team. As Chris is currently away on extended leave, I am stepping in on his behalf to question whether or not you are needing any further assistance with this, I only ask as I see a number of responses in this ticket chain showing some suggestions. If you can get back to us that would be great.
Regards,
Mark
Hi Sofian,
I hope all is well,
Mark here from the EMEA Support Team. As Chris is currently away on extended leave, I am stepping in on his behalf to question whether or not you are needing any further assistance with this, I only ask as I see a number of responses in this ticket chain showing some suggestions. If you can get back to us that would be great.
Regards,
Mark
Hi Sofian,
I hope all is well,
I just want to touch base as it's been 45 days since we last heard from you, with this I want to question whether or not you are in need of any further assistance.
If you can let me know that would be great.
Regards,
Mark
Hi Sofian,
I hope all is well,
I just want to touch base as it's been 45 days since we last heard from you, with this I want to question whether or not you are in need of any further assistance.
If you can let me know that would be great.
Regards,
Mark
Hi Sofian,
I hope all is well,
Due to age and inactivity I am going to go ahead and mark this ticket as Completed. If you wish to re-open this ticket, please do not hesitate to do so. We would be more than happy to assist where we can.
Have a great week ahead.
Regards,
Mark
Hi Sofian,
I hope all is well,
Due to age and inactivity I am going to go ahead and mark this ticket as Completed. If you wish to re-open this ticket, please do not hesitate to do so. We would be more than happy to assist where we can.
Have a great week ahead.
Regards,
Mark
Replies have been locked on this page!