7 Replies Latest reply: Jul 11, 2016 6:50 PM by Clever Anjos RSS

    Using a related table multiple times in one table ?

    ian turner

      Hi, I have a requirement for a company table to relate to user table multiple times, ie Creator, Last Edited By and Account Owner - not sure how to represent this in the dataload editor without loading the user table in 3 times, which seems a little dumb.

       

      So I have (simplified form):

       

      [Company]:

      LOAD

           company_name,

           created_by,

           updated_by,

           record_owner

      FROM [lib://Core Data/companies.xlsx]

      (ooxml, embedded labels, table is companies);

       

      [User]:

      LOAD

           user_id,

           fullname,

           role,

           email_address,

           active

      FROM [lib://Core Data/users.xlsx]

      (ooxml, embedded labels, table is users);


      I need all of the fields marked in blue to relate to the [User] Table so I can pull out the updated_by Role or the record_owners active status etc..


      Thanks

      Ian