topic Re: How to join two table based on Where Condition -- Urgent in QlikView

How to join two table based on Where Condition -- Urgent

brijeshvma — Wed, 25 Nov 2020 16:16:04 GMT

Hi All

I have two table :

FirstTable:

From Firstable;

SecondTable:

From SecondTable;

I want to join this tow table when FirstTable.B=SecondTable.B

Kindly help me on this

kaushiknsolanki — Wed, 09 Mar 2016 11:48:38 GMT

Hi,

Try this.

Load A,B,C,D From Table1

Left join

Load B,A as Table2A

From Table2;

Regards,

Kaushik Solanki

Kushal_Chawda — Wed, 09 Mar 2016 11:50:21 GMT

FirstTable:

load

From Firstable;

inner join

load

A as a

From SecondTable;

Digvijay_Singh — Wed, 09 Mar 2016 11:52:31 GMT

Something like -

FirstTable:

Load A,B,C,D

From Firstable;

Left join(FirstTable)

Load A,B

From SecondTable

Where Exists (B)