Data Transform

ireshaimali890 — Thu, 08 Jan 2026 09:29:58 GMT

can i know what is the error in this and how to solve this,

//////////////////////////////////////////////////////////
// TRANSFORM : ISSUED VOUCHERS
//////////////////////////////////////////////////////////

Issued:
LOAD
C.CARD_NUM AS VOUCHER_NUMBER,
A.ACCOUNT_ID AS ACCOUNT_ID,
A.RTL_LOC_ID AS ISSUED_LOCATION,
A.ACTIVITY_AMOUNT AS ISSUED_AMOUNT,
Date(A.RTL_BUSINESS_DATE) AS ISSUED_BUSINESS_DATE
FROM [lib://QVD/SVC_TENDER_ACCT_ACT_RAW.qvd] (qvd) A
INNER JOIN [lib://Q.qvd] (qvd) C
ON A.CARD_NUM = C.CARD_SERIAL_NUM
INNER JOIN [lib://QVD/SVC_TENDER_ACCT_RAW.qvd] (qvd) T
ON A.ACCOUNT_ID = T.ACCOUNT_ID
WHERE A.ACT_ACCT_ACTIVITY_TYPCODE = 'InstrumentActivation';

//////////////////////////////////////////////////////////
// TRANSFORM : REDEEMED VOUCHERS
//////////////////////////////////////////////////////////

Redeemed:
LOAD
C.CARD_NUM AS VOUCHER_NUMBER,
A.ACCOUNT_ID AS ACCOUNT_ID,
A.RTL_LOC_ID AS REDEEMED_LOCATION,
A.ACTIVITY_AMOUNT AS REDEEMED_AMOUNT,
Date(A.RTL_BUSINESS_DATE) AS REDEEMED_BUSINESS_DATE,
Date(MonthStart(A.RTL_BUSINESS_DATE),'MMM-YY') AS PERIOD
FROM [lib://QVD/Q.qvd] (qvd) A
INNER JOIN [lib://QVD/ACT_CARD_RAW.qvd] (qvd) C
ON A.CARD_NUM = C.CARD_SERIAL_NUM
WHERE A.ACT_ACCT_ACTIVITY_TYPCODE = 'Redemption'
AND Date(MonthStart(A.RTL_BUSINESS_DATE),'MMM-YY') = '$(PM_PERIOD)';

//////////////////////////////////////////////////////////
// TRANSFORM : MATCH ISSUE & REDEMPTION
//////////////////////////////////////////////////////////

Voucher_Fact:
LOAD
I.VOUCHER_NUMBER,
I.ACCOUNT_ID,

R.REDEEMED_LOCATION,
R.REDEEMED_AMOUNT,
R.REDEEMED_BUSINESS_DATE,

I.ISSUED_LOCATION,
I.ISSUED_AMOUNT,
I.ISSUED_BUSINESS_DATE
RESIDENT Issued AS I
INNER JOIN (Redeemed AS R)
ON I.VOUCHER_NUMBER = R.VOUCHER_NUMBER
AND I.ACCOUNT_ID = R.ACCOUNT_ID;

DROP TABLE Issued;
DROP TABLE Redeemed;

//////////////////////////////////////////////////////////
// FINAL OUTPUT
//////////////////////////////////////////////////////////

Voucher_Final:
LOAD
VOUCHER_NUMBER,

REDEEMED_LOCATION,
LM1.FRANCHISEE_ID AS REDEEMED_ENTITY,
LM1.FRANCHISEE_NAME AS REDEEMED_ENTITY_NAME,
REDEEMED_AMOUNT,
REDEEMED_BUSINESS_DATE,

ISSUED_LOCATION,
LM2.FRANCHISEE_ID AS ISSUED_ENTITY,
LM2.FRANCHISEE_NAME AS ISSUED_ENTITY_NAME,
ISSUED_AMOUNT,
ISSUED_BUSINESS_DATE
RESIDENT Voucher_Fact;

LEFT JOIN (Voucher_Final)
LOAD
RTL_LOC_ID AS REDEEMED_LOCATION,
FRANCHISEE_ID,
FRANCHISEE_NAME
RESIDENT Location_Master AS LM1;

LEFT JOIN (Voucher_Final)
LOAD
RTL_LOC_ID AS ISSUED_LOCATION,
FRANCHISEE_ID,
FRANCHISEE_NAME
RESIDENT Location_Master AS LM2;

DROP TABLE Voucher_Fact;
DROP TABLE Location_Master;

Re: Data Transform

marcus_sommer — Thu, 08 Jan 2026 14:33:42 GMT

You missed to provide the error-message.

Beside this it looked as you are trying to apply a sql-join syntax and not a Qlik syntax which has no table-aliasing and joined fixed against common fields (not supporting further adjustments and/or conditions).

topic Data Transform in Connectivity & Data Prep

Data Transform

Re: Data Transform