topic Re: ERROR: Applymap with map_id as expression in QlikView

ERROR: Applymap with map_id as expression

Anonymous — Fri, 19 Jan 2018 06:21:06 GMT

Version:12.20.20200.0 Nov2017 SR1

Error: ApplyMap error:map_id not found

MAP_C1:

Mapping LOAD * INLINE [

Heading1, Heading2

Row1, 123

Row1, 321

];

MAP_C2:

Mapping LOAD * INLINE [

Heading1, Heading2

Row1, abc

Row2, cba

];

MAP_OUT:

Load

applymap('MAP_'&Security_ID,'Row1','no map') as MAP_Result,

Security_ID

;

LOAD * INLINE [

Security_ID

];

Re: ERROR: Applymap with map_id as expression

ChennaiahNallani — Fri, 19 Jan 2018 06:31:49 GMT

Try below code

MAP_C1:

Mapping LOAD * INLINE [

Heading1, Heading2

Row1, 123

Row1, 321

];

MAP_C2:

Mapping LOAD * INLINE [

Heading1, Heading2

Row1, abc

Row2, cba

];

MAP_OUT:

Load

applymap('MAP_C1'&Security_ID,'Row1','no map') as MAP_Result,

Security_ID

;

LOAD * INLINE [

Security_ID

];

Re: ERROR: Applymap with map_id as expression

petter — Fri, 19 Jan 2018 06:43:58 GMT

The ApplyMap()-function does not allow for an expression as the mapping table name - the first parameter. It has to be a constant string.

So you could change your code to this to get it to work:

Pick( Match( Security_ID , 'C1' , 'C2')

,ApplyMap( 'MAP_C1 ', 'Row1' , 'no map' )

,ApplyMap( MAP_C2' , 'Row1' , 'no map' )

) AS MAP_Result,

Re: ERROR: Applymap with map_id as expression

petter — Fri, 19 Jan 2018 06:51:06 GMT

You could make a single mapping table and do this to achieve the same:

MAP_C:

Mapping LOAD * INLINE [

Heading1, Heading2

C1|Row1, 123

C1|Row2, 321

C2|Row1, abc

C2|Row2, cba

];

MAP_OUT:

Load

ApplyMap( 'MAP_C' , Security_ID & '|' & 'Row1' , 'no map' ) AS MAP_Result,

Security_ID

;

LOAD * INLINE [

Security_ID

];

Re: ERROR: Applymap with map_id as expression

Anonymous — Fri, 19 Jan 2018 07:06:23 GMT

Thank you, your solution is nice and elegant!

Creating two mapping tables did seem unnecessary.

I thought map_ids as expressions used to work. Was it removed recently?

Re: ERROR: Applymap with map_id as expression

petter — Fri, 19 Jan 2018 07:17:57 GMT

I don't know - I never tried to make it as an expression before.