Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
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
jagan
Luminary Alumni
Luminary Alumni

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
Author

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

maxgro
MVP
MVP

remove []


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

Not applicable
Author

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

maxgro
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
Author

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


Replacing [company master] with company master worked.

But I don't know why?


jagan
Luminary Alumni
Luminary Alumni

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.

jagan
Luminary Alumni
Luminary Alumni

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.