Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I am new to Qlikview..
I have 5 QVDs with fields mentioned below:
1. BillSummary:
LOAD ACCOUNT_NUM,
INVOICE_NET_MNY,
INVOICE_TAX_MNY,
INVOICE_NUM,
ACTUAL_BILL_DTM
FROM
(
2.
LOAD
ACCOUNT_NUM,
CUSTOMER_REF
FROM
(
3.
Product_Id_Map:
LOAD ACCOUNT_NUM as ACC_NO_PrdId,
CUSTOMER_REF as Cusref,
PRODUCT_ID,
if(CHARGE_TYPE=1,CHARGE_COST_MNY/1000) as MRC,
if(CHARGE_TYPE=2,CHARGE_COST_MNY/1000) as NRC,
CHARGE_COST_MNY,
CHARGE_TYPE
FROM
(
4.
Hi,
Its better if you Map the second table and load as mapping table and in the third table do not rename
CUSTOMER_REF field and it will associate with the BillSummary table for more see the script below.
Or you can try with do not rename ACCOUNT_NUM field also instead of CUSTOMER_REF and you can use ACCOUNT_NUM for association
MapTab:
Mapping LOAD
ACCOUNT_NUM,
CUSTOMER_REF
FROM
(
BillSummary:
LOAD
ACCOUNT_NUM,
ApplyMap('MapTab',ACCOUNT_NUM,'Unknown') as CUSTOMER_REF,
INVOICE_NET_MNY,
INVOICE_TAX_MNY,
INVOICE_NUM,
ACTUAL_BILL_DTM
FROM
(
Product_Id_Map:
LOAD
ACCOUNT_NUM as ACC_NO_PrdId,
ACCOUNT_NUM,
CUSTOMER_REF as Ref,
PRODUCT_ID,
if(CHARGE_TYPE=1,CHARGE_COST_MNY/1000) as MRC,
if(CHARGE_TYPE=2,CHARGE_COST_MNY/1000) as NRC,
CHARGE_COST_MNY,
CHARGE_TYPE
FROM
(
Hope this helps you
Regards
Anand