Mapping load (not working)

[kartik]

Hi Everyone.

If I use mapping load in the Resident table and use that column in another table then why it's not working?

T1:

load
"CMPN_NO" &'|'& "CORP_NO" &'|'& "CMM_GRP_CODE" &'|'& "CMM_CODE" as key,
"CMPN_NO",
"CORP_NO",
"CMM_GRP_CODE",
"CMM_CODE",
"CMM_CODE_NAME";
SQL SELECT "CMPN_NO",
"CORP_NO",
"CMM_GRP_CODE",
"CMM_CODE",
"CMM_CODE_NAME"
FROM DMSDBA."CMM_CMCD_TB"

where

"CMPN_NO" = 'K'

AND "CORP_NO" = 'A10VA'

AND "CMM_GRP_CODE"= 'DSC0006'

AND "CMM_CODE"= '01';

left join(T1)

T2:

LOAD
"CMPN_NO" &'|'& "CORP_NO" &'|'& "CMM_GRP_CODE" &'|'& "CMM_CODE" as key,
"CMPN_NO",
"CORP_NO",
"CMM_GRP_CODE",
"CMM_CODE",
"LANG_CODE",
"CMM_CODE_TXT";
SQL SELECT "CMPN_NO",
"CORP_NO",
"CMM_GRP_CODE",
"CMM_CODE",
"LANG_CODE",
"CMM_CODE_TXT"
FROM DMSDBA."CMM_CMCDLG_TB"
where "LANG_CODE" ='en'

;

T1_final:
mapping load
// "CMM_CODE_TXT",
// "CMM_CODE_NAME",
key as T1_key,
if(isnull("CMM_CODE_TXT"),("CMM_CODE_NAME"),"CMM_CODE_TXT") as V_codename
Resident T1;
drop table T1;

and in this table, I'm using it.

Enquiry:
LOAD
"EQRY_MAKER_CODE" & ' | ' & "EQRY_EXCHG_MODEL_CODE" as Comp_key,
ApplyMap('T1_final',T1_key) as V_codename,
"EQRY_EXCHG_YN" ,
"EQRY_ENQRY_NO",
"EQRY_EXCHG_SRC_CODE",
"EQRY_EXPCT_PRICE" ,
"EQRY_QUOTD_PRICE" ,
"EQRY_PRESENT_CAR_YN" ,
"EQRY_P_MODL_YEAR" ,
"EQRY_EVAL_YN" ,
"EQRY_EXCH_DN" ,
"EQRY_FINAL_BP" ,
"EQRY_EXCHG_MODEL_CODE",
"EQRY_MAKER_CODE";
SQL SELECT "EQRY_EXCHG_YN",
"EQRY_EXCHG_SRC_CODE",
"EQRY_ENQRY_NO",
"EQRY_EXPCT_PRICE",
"EQRY_QUOTD_PRICE" ,
"EQRY_PRESENT_CAR_YN",
"EQRY_P_MODL_YEAR",
"EQRY_EVAL_YN",
"EQRY_EXCH_DN",
"EQRY_FINAL_BP",
"EQRY_EXCHG_MODEL_CODE",
"EQRY_MAKER_CODE"
FROM DMSDBA."CRM_SCEQRY_TB";

Why this is giving an error.

[anat · Accepted solution]

it says 'T1_key' not found in Enquiry table.

try like below
ApplyMap('T1_final',"EQRY_MAKER_CODE" & ' | ' & "EQRY_EXCHG_MODEL_CODE" ) as V_codename,

[kartik]

Ohh okay. that means in mapping load, the key should be there in the current table where we use applymap().

[anat]

https://help.qlik.com/en-US/sense/November2021/Subsystems/Hub/Content/Sense_Hub/Scripting/MappingFun...