Discussion board where members can get started with QlikView.
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.
LOAD ID as LeaseTpeId,
SQL SELECT *
Load id as LeaseId
,ApplyMap('LeaseType',ID) as Value
sql select * from lms.Lease;
below mentioned is the error :
Feild ID not found.
Kindly help on where is the issue.
Thanks in advance,'
Go to Solution.
Once check the Column name spellings and try
i suppose that field "ID" doesnot exist in your source.
so you may use LeaseTypeid as Input
,ApplyMap('LeaseType',LeaseTypeid) as Value
if you want to use ApplyMap,
you need a
ID as LeaseTpeId,
,ApplyMap('LeaseType',ID, null()) as Value
If you continue having the same error it is because you don't have an ID field... If so, which is your field name?
Thanks a lot Sudhakar , my column name spellings were incorrect.
Try 'id' instead of "ID" in the Applymap function
Mapping LOAD ID as LeaseTpeId,
,ApplyMap('LeaseType',id) as Value