Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Mapping Load Scripting

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.

2 Replies
swuehl
MVP
MVP

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