topic Re: Applymap not working in QlikView

Applymap not working

Thu, 06 Mar 2014 20:13:47 GMT

I am applying map on SAP sales and distribution module tables.

billing header(VBRK) field-

CompanycodeBUKRS.VBRK field name ( which is BUKRS (company code ) of SAP table)

and

Company master- T001

CompanycodeBUKRS.T001(BUKRS)

company master has two field

CompanycodeBUKRS.T001,company name

I have written applymap('[company master]',CompanycodeBUKRS.VBRK) as CompnyName.

But the output is not coming.

What can be the problem ?

Re: Applymap not working

Thu, 06 Mar 2014 20:28:36 GMT

Can you try this:

Company_Master:

Mapping Load

CompanycodeBUKRS.T001,

company name

From Source;

Then in the table

applymap('Company_Master',CompanycodeBUKRS.VBRK,'Missing: '& CompanycodeBUKRS.VBRK) as CompnyName

Also first Load Company_Master without Mapping prefix and see if that table is looking good(just for testing).

Also there needs to be an exact match between CompanycodeBUKRS.T001 and CompanycodeBUKRS.VBRK, else it will fail.

Even the data format should be same(like both string or both numbers).

Re: Applymap not working

maxgro — Thu, 06 Mar 2014 20:29:45 GMT

remove []

applymap('company master',CompanycodeBUKRS.VBRK) as CompnyName.

Re: Applymap not working

Thu, 06 Mar 2014 20:30:25 GMT

Hi Santosh,

don't use a blank in the name of the mapping table.

applymap('company_master',CompanycodeBUKRS.VBRK) as CompnyName.

should i.e. do the job.

Re: Applymap not working

maxgro — Thu, 06 Mar 2014 20:35:02 GMT

[map1 a]:

mapping load * inline [

from, to

1, one

2, two

3, three ] ;

T1:

load

ApplyMap ('map1 a', 2 ) as colok // this works

AutoGenerate 1;

T2:

load

ApplyMap ('[map1 a]', 2 ) as colko // this doesn't

AutoGenerate 1;

Re: Applymap not working

Fri, 07 Mar 2014 04:21:27 GMT

applymap('company master',CompanycodeBUKRS.VBRK) as CompnyName.

Replacing [company master] with company master worked.

But I don't know why?

Re: Applymap not working

jagan — Fri, 07 Mar 2014 05:26:40 GMT

Hi Santosh,

When you are giving single quote then there is not need [], if you use the [] then it is also considered as the Dimension name.

Regards,

Jagan.

Re: Applymap not working

jagan — Fri, 07 Mar 2014 06:04:41 GMT

Hi Santosh,

Please close this discussion by giving Correct and Helpful answers to the posts which are useful for you. It helps others in finding answers for similar scenarios.

Regards,

Jagan.