Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
My usual newbie type question.
I have got 3 headers named [Added By], [Last Maint By] and [Closed By] on one spreadsheet. All 3 of these are actually employee ID's.
I then have another spreadsheet which has the header [Employees] which is also the employee ID. I want to map all 3 off those headers to this header so that I can pull back information on the employees who are opening and closing calls for example [Position] and [Team].
Can this be done at all using mapping loads and apply map?
Any help would be appreciated.
I think you can apply the same principle as for a canonical date:
e.g.
TableA:
LOAD Recno() as RecID, [Added By], [Last Maint By], [Closed By] ....
FROM YourExcelTableASource;
TableB:
LOAD [Employees], ...
FROM YourExcelTableBSource;
CROSSTABLE (Role, Employees)
LOAD RecID, [Added By], [Last Maint By], [Closed By]
RESIDENT TableA;
please post some sample data (excel) and your expected result.
thanks
regards
Marco