Qlik Community

Ask a Question

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
cancel
Showing results for 
Search instead for 
Did you mean: 
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 ?


1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

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.

View solution in original post

7 Replies
Not applicable

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

remove []


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

Not applicable

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

[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

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


Replacing [company master] with company master worked.

But I don't know why?


MVP & Luminary
MVP & Luminary

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.

View solution in original post

MVP & Luminary
MVP & Luminary

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.