topic Mapping Load Scripting in QlikView

Mapping Load Scripting

Mon, 16 May 2016 10:34:47 GMT

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.

Re: Mapping Load Scripting

swuehl — Mon, 16 May 2016 16:14:20 GMT

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

MarcoWedel — Mon, 16 May 2016 21:37:15 GMT

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

thanks

regards

Marco