Mapping of Values

[#1]

I have a number of reports I extract into Qlikview.

I need to change the name of a certain value for multiple extracts; however the change needs to be different for each one.

I am trying to use mapping, however the first mapping overwrites the second one.

Is there a way of having multiple mappings, one for each extract?

Example

MAPPING:
MAPPING LOAD * inline [

Old ,New

MSIE 7.0, MSIE 7.0 - MSIE 8.0 Compatibility Mode];

map Browser using MAPPING;

LOAD Field1, Field2 as Browser, Hits, TimePeriod, StartDate, EndDate, 'Trident 4.0' as Data, 'Internal' as User;SQL SELECT * FROM Report1 WHERE Field1 IS NOT NULL AND Field2 IS NOT NULL AND timeperiod='%start=month;duration=month+1%';

MAPPING:
MAPPING LOAD * inline [

Old ,New

MSIE 7.0, MSIE 7.0 - MSIE 9.0 Compatibility Mode];
map Browser using MAPPING;
LOAD Field1, Field2 as Browser, Hits, TimePeriod, StartDate, EndDate, 'Trident 5.0' as Data, 'Internal' as User;SQL SELECT * FROM Report2 WHERE Field1 IS NOT NULL AND Field2 IS NOT NULL AND timeperiod='%start=month;duration=month+1%';

Current Result

Browser

MSIE 7.0 - MSIE 8.0 Compatibility Mode

MSIE 8.0

MSIE 9.0

Desired Result

Browser

MSIE 7.0 - MSIE 8.0 Compatibility Mode

MSIE 7.0 - MSIE 9.0 Compatibility Mode

MSIE 8.0

MSIE 9.0

[er_mohit · Accepted solution]

MAPPING:

MAPPING LOAD * inline [

Old ,New

MSIE 7.0, MSIE 7.0 - MSIE 8.0 Compatibility Mode];

map Browser using MAPPING;

LOAD Field1, Field2 as Browser, Hits, TimePeriod, StartDate, EndDate, 'Trident 4.0' as Data, 'Internal' as User;SQL SELECT * FROM Report1 WHERE Field1 IS NOT NULL AND Field2 IS NOT NULL AND timeperiod='%start=month;duration=month+1%';

MAPPING1:

CONCATENATE(MAPPING)

MAPPING LOAD * inline [

Old ,New

MSIE 7.0, MSIE 7.0 - MSIE 9.0 Compatibility Mode];

map Browser using MAPPING1;

LOAD Field1, Field2 as Browser, Hits, TimePeriod, StartDate, EndDate, 'Trident 5.0' as Data, 'Internal' as User;SQL SELECT * FROM Report2 WHERE Field1 IS NOT NULL AND Field2 IS NOT NULL AND timeperiod='%start=month;duration=month+1%';

[#3]

HI

THIS SAMPLE IS CONSIDERED ACCORDING TO YOUR CODE.

AND IT WORKING FINE.

MAPPING:

Mapping LOAD  * INLINE [

    A, B

    ES, ABCDFER

    US, GHYUI

];

MAP D using MAPPING;

LOAD  * INLINE [

    D

    ES

    US

    RS

];

MAPPING1:

Mapping LOAD  * INLINE [

    A, B

    ES, QWE

    RS, FGR

] ;

MAP D_NEW using MAPPING1;

LOAD D AS D_NEW,  * INLINE [

    D

    ES

    US

    RS

];

JOIN:

LOAD D

Resident MAPPING;

LOAD D_NEW AS D

Resident MAPPING1;

[#4]

TRY THIS WORKING FINE

MAPPING:
MAPPING LOAD * inline [

Old ,New

MSIE 7.0, MSIE 7.0 - MSIE 8.0 Compatibility Mode];

map Browser using MAPPING;

LOAD Field1, Field2 as Browser, Hits, TimePeriod, StartDate, EndDate, 'Trident 4.0' as Data, 'Internal' as User;SQL SELECT * FROM Report1 WHERE Field1 IS NOT NULL AND Field2 IS NOT NULL AND timeperiod='%start=month;duration=month+1%';

MAPPING1:
MAPPING LOAD * inline [

Old ,New

MSIE 7.0, MSIE 7.0 - MSIE 9.0 Compatibility Mode];
map Browser AS Browser_NEW using MAPPING1;
LOAD Field1, Field2 as Browser_NEW, Hits, TimePeriod, StartDate, EndDate, 'Trident 5.0' as Data, 'Internal' as User;SQL SELECT * FROM Report2 WHERE Field1 IS NOT NULL AND Field2 IS NOT NULL AND timeperiod='%start=month;duration=month+1%';

JOIN:

LOAD Browser

Resident MAPPING;

LOAD Browser_NEW AS Browser

Resident MAPPING1;