topic For 1 field - Applymap(), for more than 1 ? in QlikView

For 1 field - Applymap(), for more than 1 ?

mohan2391 — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I understood clearly that Applymap() is useful when we want to add 1 field/column to other table by keeping 1 reference field (Total 2 fields in mapping table).

I used this in my qvw and worked perfect.

Now i'm in a need that there I want to add 2 fields from 1 table to other big table by keeping 1 reference field (Total 3 fields in mapping table).

How can I achieve this ?

Which function do i need to use ?

Please help me.

Thank You

Re: For 1 field - Applymap(), for more than 1 ?

Mark_Little — Thu, 27 Oct 2016 10:44:16 GMT

HI,

Well the first option would be to do two apply maps. One for each extra field.

Look at using Join, Most likely left join.

Mark

Re: For 1 field - Applymap(), for more than 1 ?

sunny_talwar — Thu, 27 Oct 2016 10:46:04 GMT

You can create two mapping tables to do this

or you can concatenate the two fields which are going to get mapped into one so for instance

MappingTable:

Mapping

LOAD Field1,

Field2&'|'&Field3 as Field4

FROM ...

and then when you are mapping them you can use SubField() function to extract them back to there normal value

Fact:

LOAD Field1,

SubField(ApplyMap('MappingTable', Field1), '|', 1) as Field2,

SubField(ApplyMap('MappingTable', Field1), '|', 2) as Field3,

....

Re: For 1 field - Applymap(), for more than 1 ?

trdandamudi — Thu, 27 Oct 2016 10:49:18 GMT

You can split the mapping table into two tables where you have total 3 fields in the mapping table.

For example if you have a mapping table with three fields like below:

Name

Code

Then split them into two mapping tables as below:

Table1:

Name

Table2

Code

Hope this helps...

Re: For 1 field - Applymap(), for more than 1 ?

gireesh1216 — Thu, 27 Oct 2016 10:58:25 GMT

If u have 3 fields please split to two tables like below.

Example:

Load

Empid,

Name,

Phone_Num

from path;

Table1:

mappling load

Empid,

Name

from path;

Table2:

mappling load

Empid,

Phone_Num

from path;

load

id,

ApplyMap('Table1', Name) as Fieldname,

ApplyMap('Table2', Name) as Field2name

from path;

Thanks

Gireesh