Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to join two tables as per below where clause

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

1 Solution

Accepted Solutions
Not applicable
Author

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;

View solution in original post

3 Replies
Not applicable
Author

Also I have prepared separate QVDs for both the tables..

Not applicable
Author

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;

Not applicable
Author

Thanks Pedro