12 Replies Latest reply: Jan 19, 2015 8:22 AM by Alex Hamilton McLeod RSS

    One field preventing concatenation of two tables

      I am trying to concatenate two tables, which I have been able to successfully do up to a point. Salesforce is the source of the information.

       

      The problem arises when I try and do the same LEFT JOIN on those individual tables. It is at this point that the [Record Owner] field which I am trying to add is NOT recognised as an identical field, and therefore the tables are not concatenated.

       

      Below is a shortened version of the script

       


      1st TABLE

       

      Contacts:

      LOAD Id as ContactId,

          AccountId,

          Email,

          Phone,

          Title,

          Inactive_Contact__c,

          OwnerId AS ContactOwnerID,

          Name AS ContactName;

      SQL SELECT *

      FROM Contact

      WHERE AccountId != NULL;



      RecordOwners:

      LEFT JOIN (Contacts)

      LOAD Id AS ContactOwnerID,

          Name AS [Record Owner];

      SQL SELECT *

      FROM User;




      2nd TABLE

       

      Contacts:

      LOAD Id as ContactId,

          AccountId,

          Email,

          Phone,

          Title,

          Inactive_Contact__c,

          OwnerId AS ContactOwnerID,

          Name AS ContactName;

      SQL SELECT *

      FROM Contact

      WHERE AccountId != NULL;

       

       

      RecordOwners:

      LEFT JOIN (Contacts)

      LOAD Id AS ContactOwnerID,

          Name AS [Record Owner];

      SQL SELECT *

      FROM User;

       

       

       

      There are other tables in my script, but this is how the two offending tables end up

       

      export.png