Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have employee ID in 1 excel spreadsheet, along with other bits of informaiton about machinery
and another spreadsheet with the names for corresponding employee ID's
I'm trying to create a pivot table which uses employees names correlated to information about machinery, rather than using employer ID.
When loading both tables, ensure that the Employee ID field is written in exact the same way in both tables - you can rename the fields like e.g.
File1:
LOAD
[employee ID] as EmployeeID,
...
from...file1
File2:
LOAD
EmpID as EmployeeID,
...
from ....file2
Please provide sample data..