Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have this SQL Logic. FNC_GET_CODE_NAME ('DSC0006', EQRY_EXCHG_SRC_CODE,'en') AS EXCHANGE_CNL
, and the query for this logic is given below. How can I write it in Qlik sense ??
SELECT
NVL(T2.CMM_CODE_TXT,
T1.CMM_CODE_NAME) AS V_CODE_NAME
FROM CMM_CMCD_TB T1 LEFT OUTER JOIN CMM_CMCDLG_TB T2 ON T1.CMPN_NO = T2.CMPN_NO
AND T1.CORP_NO = T2.CORP_NO
AND T1.CMM_GRP_CODE = T2.CMM_GRP_CODE
AND T1.CMM_CODE = T2.CMM_CODE
AND T2.LANG_CODE = 'en'
WHERE T1.CMPN_NO = 'K'
AND T1.CORP_NO = 'A10VA'
AND T1.CMM_GRP_CODE= 'DSC0006'
AND T1.CMM_CODE= '01';
and the table used in this is
T1:
LOAD
"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";
T2:
LOAD
"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";
T1:
LOAD
"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';
;
join(T1)
T2:
LOAD
"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:
LOAD
"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';
;
join(T1)
T2:
LOAD
"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';
Thanks man!!! Super'b..
I also have this query
EQRY_PRESENT_CAR_YN AS PRESENT_CAR_YN,
EQRY_P_MODL_YEAR as MDL_YEAR,
EQRY_EXCHG_YN AS EXCHANGE,
EQRY_EXCHG_SRC_CODE AS EXCHANGE_CNL_CD,
FNC_GET_CODE_NAME ('DSC0006', EQRY_EXCHG_SRC_CODE,'en') AS EXCHANGE_CNL, - this has done but how can I add this too in the whole logic
EQRY_EVAL_YN AS EVALUATION,
EQRY_EXPCT_PRICE AS EXPECTED_PRICE,
EQRY_QUOTD_PRICE AS QUOTED_PRICE,
EQRY_EXCH_DN AS EXCHANGE_DN,
EQRY_FINAL_BP AS BUYING_PRICE,
(SELECT A.MAKE_FULL_DSCTN FROM SAL_UCMAKE_TB A WHERE A.MAKE_MAKER_CODE=EQRY_MAKER_CODE ) AS OEM,
(SELECT B.MODL_FULL_DSCTN FROM SAL_UCMODL_TB B WHERE B.MODL_MODEL_CODE=EQRY_EXCHG_MODEL_CODE AND B.MODL_MAKER_CODE=EQRY_MAKER_CODE) AS MODEL
and the table used in this is this
Enquiry:
LOAD
"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";
uc_maker:
LOAD
"MAKE_MAKER_CODE",
"MAKE_FULL_DSCTN" as OEM;
SQL SELECT "MAKE_MAKER_CODE",
"MAKE_FULL_DSCTN"
FROM DMSDBA."SAL_UCMAKE_TB";
Uc_model:
LOAD
"MODL_MAKER_CODE",
"MODL_MODEL_CODE",
"MODL_FULL_DSCTN" as MODEL;
SQL SELECT "MODL_MAKER_CODE",
"MODL_MODEL_CODE",
"MODL_FULL_DSCTN"
FROM DMSDBA."SAL_UCMODL_TB";
Anyone who knows, pls help.