Using a related table multiple times in one table ?
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):
FROM [lib://Core Data/companies.xlsx]
(ooxml, embedded labels, table is companies);
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..