Skip to main content

Edition: Desktop Professional

Version: 2020.4

Machine: Mac

 

Referencing this article (https://help.tableau.com/current/pro/desktop/en-us/examples_salesforce.htm) it should be possible to do a left or inner join with a Salesforce Connection, Custom SQL, and multiple object tables. Does anyone have experience with this?

 

I'm in the process of setting up my data model and trying to join Lead with Opportunity in a single table using the ConvertedOpportunityId as the common identifier but the extract does not bring back data from the matched Opportunity. Working with a subset of one table does work as expected.

 

Any help would be much appreciated as I have been racking my brain on this all day and there doesn't seem to be any other documentation or forums on this subject.

 

Thanks in advance.

1 answer
  1. Jun 18, 2021, 6:01 PM

    Hi Jay,

     

    When you mentioned: But the extract does not bring back data from the matched Opportunity

    Does this mean the join is not working at all? Have you checked the join criteria?

     

    Thanks,

     

    Mavis