topic Re: Mapping of Values in QlikView

Mapping of Values

Wed, 01 May 2013 12:03:48 GMT

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

Re: Mapping of Values

er_mohit — Wed, 01 May 2013 12:47:38 GMT

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%';

Re: Mapping of Values

Wed, 01 May 2013 13:01:08 GMT

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 [

];

MAPPING1:

Mapping LOAD * INLINE [

A, B

ES, QWE

RS, FGR

] ;

MAP D_NEW using MAPPING1;

LOAD D AS D_NEW, * INLINE [

];

JOIN:

LOAD D

Resident MAPPING;

LOAD D_NEW AS D

Resident MAPPING1;

Re: Mapping of Values

Wed, 01 May 2013 13:06:30 GMT

TRY THIS WORKING FINE

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;