Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am a newbie in qlikview and quite unaware of qlikview scripting...
please help me in joining these two tables as per the below sql statement.
select ORGANIZATION_CODE, GROSS_WRITTEN_PREMIUM, DISCOUNT, OTHER_CHARGES, GST, COMMISSION1, COMMISSION2, NET_WRITTEN_PREMIUM, TRANSACTION_NUMBER
from DIM_ORGANIZATION, FT_PREMIUM_TRANSACTION
where DIM_ORGANIZATION.ORGANIZATION_KEY = FT_PREMIUM_TRANSACTION.COMPANY_PARTY_KEY
Please help me its little urgent..
Many Thanks
Kriti
Try somenthing like this
LOAD
ORGANIZATION_CODE,
GROSS_WRITTEN_PREMIUM,
DISCOUNT,
OTHER_CHARGES,
GST, COMMISSION1,
COMMISSION2,
NET_WRITTEN_PREMIUM,
TRANSACTION_NUMBER;
SQL SELECT
ORGANIZATION_CODE, GROSS_WRITTEN_PREMIUM, DISCOUNT, OTHER_CHARGES, GST, COMMISSION1, COMMISSION2,
NET_WRITTEN_PREMIUM,
TRANSACTION_NUMBER
FROM
DIM_ORGANIZATION INNER JOIN FT_PREMIUM_TRANSACTION ON
DIM_ORGANIZATION.ORGANIZATION_KEY = FT_PREMIUM_TRANSACTION.COMPANY_PARTY_KEY;
Also I have prepared separate QVDs for both the tables..
Try somenthing like this
LOAD
ORGANIZATION_CODE,
GROSS_WRITTEN_PREMIUM,
DISCOUNT,
OTHER_CHARGES,
GST, COMMISSION1,
COMMISSION2,
NET_WRITTEN_PREMIUM,
TRANSACTION_NUMBER;
SQL SELECT
ORGANIZATION_CODE, GROSS_WRITTEN_PREMIUM, DISCOUNT, OTHER_CHARGES, GST, COMMISSION1, COMMISSION2,
NET_WRITTEN_PREMIUM,
TRANSACTION_NUMBER
FROM
DIM_ORGANIZATION INNER JOIN FT_PREMIUM_TRANSACTION ON
DIM_ORGANIZATION.ORGANIZATION_KEY = FT_PREMIUM_TRANSACTION.COMPANY_PARTY_KEY;
Thanks Pedro