Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
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
MVP
MVP

Re: Mapping Load Scripting

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

Re: Mapping Load Scripting

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

thanks

regards

Marco

Community Browser