Mapping Load Scripting

[#1]

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.

[swuehl]

I think you can apply the same principle as for a canonical date:

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;

The Crosstable Load

[MarcoWedel]

please post some sample data (excel) and your expected result.

thanks

regards

Marco