topic Re: Logical Question in QlikView

Logical Question

vanderson009 — Thu, 07 Aug 2014 10:55:44 GMT

Hi Community,

There is three tables-A with 25 records,

B with 15 records and C with 30 records.

And you are doing Left Join Between A and B,

right join between B and C . What would be the end result?

-- Regards,

Villyee Anderson

Re: Logical Question

VishalWaghole — Thu, 07 Aug 2014 10:57:08 GMT

Hi Villyee,

There will be 30 recordes.

from first join you will get 25 records

second will get 30 records

-- Regards,

Vishal Waghole

Re: Logical Question

rajat2392 — Thu, 07 Aug 2014 11:09:10 GMT

Hi Villyee,

It depends on the column common between the tables.

If there is no common column, then it becomes a cartesian product. First join will result in 25x15=375 rows and Second join will result in 30x15=450 rows.

If there is a common column between the tables, then

First join will result 25 rows

Second Join will result in 30 rows.

Re: Logical Question

Anonymous — Thu, 07 Aug 2014 11:10:00 GMT

Hi Villyee,

After apply the join condition in table A,B & C

A Left join B then you will get 25 records

and B Right join C then you will get the 30 records

Thanks

Re: Logical Question

tresB — Thu, 07 Aug 2014 11:14:34 GMT

Join (SQL) - Wikipedia, the free encyclopedia

It depends on multiple factors like:

Number of fields in column between the two tables
Number of field values common

Re: Logical Question

rubenmarin — Thu, 07 Aug 2014 11:18:46 GMT

Hi,

You can know that the minimum will be 30 rows, in case there are no coincidences between tables. In other case it depends on coincidendes...

Table A		Table B		Result
ID	DataA	ID	DataB	ID	DataA	DataB
1	A	1	D	1	A	D
2	B	1	E	1	A	E
3	C	1	F	1	A	F
				2	B
				3	C

If there are no coincidences, in left join Table A remains the same.

Re: Logical Question

vanderson009 — Thu, 07 Aug 2014 11:36:20 GMT

Thank you all...........