Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Applymap not working

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 ?


Tags (2)
1 Solution

Accepted Solutions
MVP
MVP

Re: Applymap not working

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.

7 Replies
Not applicable

Re: Applymap not working

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).

MVP
MVP

Re: Applymap not working

remove []


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

Not applicable

Re: Applymap not working

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.

RR

MVP
MVP

Re: Applymap not working

[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;

Not applicable

Re: Applymap not working

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


Replacing [company master] with company master worked.

But I don't know why?


MVP
MVP

Re: Applymap not working

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.

MVP
MVP

Re: Applymap not working

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.

Community Browser