Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
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

Tags (1)
1 Solution

Accepted Solutions
Not applicable

Re: How to join two tables as per below where clause

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;

3 Replies
Not applicable

Re: How to join two tables as per below where clause

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

Not applicable

Re: How to join two tables as per below where clause

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

Re: How to join two tables as per below where clause

Thanks Pedro

Community Browser