topic Re: Apply Map function Issue in QlikView

Apply Map function Issue

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

hi experts ,

I am trying to map 2 table with the help of apply map function , but there seems to be a very minor issue which i am not able to recegnize it ..

please help me know if i have taken the right approach ::

below is the code which i am implementing.

Mapping LeaseType:

LOAD ID as LeaseTpeId,

Value;

SQL SELECT *

FROM mdm.LeaseType;

Lease:

Load id as LeaseId

,Parentid

,orglocationid

,leasenumber

,leasecategoryid

,LeaseTypeid

,ApplyMap('LeaseType',ID) as Value

,leasestatusid

,isstandardagreement

,languageid;

sql select * from lms.Lease;

below mentioned is the error :

Feild ID not found.

Kindly help on where is the issue.

Thanks in advance,'

Re: Apply Map function Issue

Anonymous — Tue, 25 Sep 2018 10:55:05 GMT

i suppose that field "ID" doesnot exist in your source.

so you may use LeaseTypeid as Input

,ApplyMap('LeaseType',LeaseTypeid) as Value

Re: Apply Map function Issue

maxgro — Tue, 25 Sep 2018 11:00:10 GMT

if you want to use ApplyMap,

you need a

mapping load

Mapping LeaseType:

Mapping LOAD

ID as LeaseTpeId,

Value;

SQL SELECT *

FROM mdm.LeaseType;

Re: Apply Map function Issue

lanlizgu — Tue, 25 Sep 2018 11:01:42 GMT

Try:

LeaseType:

Mapping LOAD

ID,

Value;

SQL SELECT *

FROM mdm.LeaseType;

Lease:

Load id as LeaseId

,Parentid

,orglocationid

,leasenumber

,leasecategoryid

,LeaseTypeid

,ApplyMap('LeaseType',ID, null()) as Value

,leasestatusid

,isstandardagreement

,languageid;

sql select * from lms.Lease;

If you continue having the same error it is because you don't have an ID field... If so, which is your field name?

Thank you.

Re: Apply Map function Issue

bvssudhakar — Tue, 25 Sep 2018 11:06:07 GMT

Hi Chandana,

Once check the Column name spellings and try

Re: Apply Map function Issue

Anonymous — Tue, 25 Sep 2018 11:09:19 GMT

Thanks a lot Sudhakar , my column name spellings were incorrect.

Re: Apply Map function Issue

pooja_prabhu_n — Tue, 25 Sep 2018 11:12:59 GMT

Hi,

Try 'id' instead of "ID" in the Applymap function

LeaseType:

Mapping LOAD ID as LeaseTpeId,

Value;

SQL SELECT *

FROM mdm.LeaseType;

Lease:

Load id as LeaseId

,Parentid

,orglocationid

,leasenumber

,leasecategoryid

,LeaseTypeid

,ApplyMap('LeaseType',id) as Value

,leasestatusid

,isstandardagreement

,languageid;

sql select * from lms.Lease;