topic Re: Fetching multiple fields using applymap in QlikView

Fetching multiple fields using applymap

Wed, 25 Nov 2020 16:16:04 GMT

Hi all i have a requirement where i want to bring 3 fields using applymap

Table1

Table2

Id country region age

1 i a 26

2 b c 11

How can i achieve it

maxgro — Tue, 22 Nov 2016 20:43:55 GMT

If I understand,

you can use a separator in the second field of fhe mapping table

MapTable:

Mapping load * inline [

f1, f2

1, i|a|26

2, b|c|11

];

load

subfield(ApplyMap('MapTable', f,), '|', 1) as m1,

subfield(ApplyMap('MapTable', f,), '|', 2) as m2,

subfield(ApplyMap('MapTable', f,), '|', 3) as m3

inline [

];

swuehl — Tue, 22 Nov 2016 20:46:58 GMT

You can either JOIN the tables

MAP:

MAPPING

LOAD Id, country &'|'& region &'|'& age as value

FROM Table2;

LOAD Id,

Subfield( Applymap('MAP', Id), '|',1) as country,

Subfield( Applymap('MAP', Id), '|',2) as region,

Subfield( Applymap('MAP', Id), '|',3) as age,

...

Tue, 22 Nov 2016 21:39:03 GMT

Thank you stefan it solved the problem

I have another roblem which is cracking my mind can you please help me please