Merge two salesforce objects RRS feed

  • Question

  • Hi everyone.

    I am currently trying to pull data from multiple salesforce objects using the connector. 

    For example, I want to pull all Opportunities and their related Account information. Is there an easy way to "merge" these two objects into one table?


    Friday, June 5, 2015 1:16 AM


  • Yes: Both tables should have been passed to the query editor as separate queries already. Then you choose any of them and add a step: Home - Combine - Merge queries: Choose the table to merge.

    Select their key attributes - OK and then expand the result column.


    Friday, June 5, 2015 4:26 AM