Can you create a left outer join to a Connector-based view (e.g. Google Sheets view)?

James Ormrod shared this question 2 years ago
Answered

Hi,


I am currently looking at the uses for the new Google Sheets connector views in 7.2 and one key implementation would be to join one of these views to an existing data set using a Left Outer Join in a report, is this possible?


In particular is there any restriction on this if you are using a freehand SQL view in Yellowfin?


If neither of these are possible, is there any other way through Yellowfin that the Google Sheets connector could be joined to an existing data set in Yellowfin?


Thanks,


James

Comments (3)

photo
1

James, great questions. We have a few ideas we are kicking around, we will have an update to you shortly. Thanks

photo
1

Hi Lee,


Thanks for the response, I look forward to reading and trying your ideas.


Regards

photo
1

Hi James,


Thanks for sending in the question; but unfortunately I think you are out of luck here...


Currently connector based views are a bit limited in the following aspects:


  1. The view cannot be edited (the joins)
  2. Connector based data sources/views cannot be included in advanced sub queries (so you can't join a sub query with a left join).

Apologies for the bit of bad news here. The best work around we can think of would be to create a report from your Google sheet, then export that report from Yellowfin in .csv format. You could then re-import that particular .CSV back into Yellowfin, and join your existing report to the .CSV data (the data will be stored in whichever database you have defined as 'writable').


I'm not sure if this workaround is ideal in your case, but I just wanted to mention this as a possible solution. I apologize for any inconvenience this may cause. Please feel free to let us know if you have any questions! Have a great rest of your day!


Kind Regards,


Dustin