Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
This is the query. Actually, I need to convert this SQL logic to Qlik sense
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";
thanks and regards,
kartik
Anyone knows how can I make OEM column in Qlik using SQL query?