topic Re: ghow many records fetch while reload ? in QlikView

ghow many records fetch while reload ?

Tue, 05 Mar 2013 09:32:22 GMT

Hello

I used two tables, parent table which has 1000 records and child table which has 2300 records...

totally how many records it will show while joining the table ?????

Re: ghow many records fetch while reload ?

manideep78 — Tue, 05 Mar 2013 09:40:54 GMT

That is based on the join you use. I don't how exactly your data is structured. I think you have a common field in both tables. so that you can join two tables with help of any joins(LEFT,RIGHT,INNER,OUTER).

If you use left join you will get 1000 records if you use right join you will get 2300 records.

Instead if you use inner join you will get only matched columns data.

By default QlikView will use outer join to combine two tables if you doesn't provide any join condition.

Re: ghow many records fetch while reload ?

sushil353 — Tue, 05 Mar 2013 09:42:05 GMT

It depend on which join u r using.

If there is no join condition. Then by default qlikview use Full outer join.

if u tell the join condition and table structure then i let you know, hwo many record you will get

Regards,

Sushil

Re: ghow many records fetch while reload ?

Tue, 05 Mar 2013 09:42:53 GMT

It depends on the match..by default qlikview will perform outer join.. for the below example you will get 4 rows.

eg..

Parent:

LOAD * INLINE [

Id, Name

1, A

2, B

3, C

];

Temp:

Join (Parent)

LOAD * INLINE [

Id, Sub, Marks

1, Sub1, 10

1, Sub2, 20

2, Sub1, 30

];

Re: ghow many records fetch while reload ?

nirav_bhimani — Tue, 05 Mar 2013 09:47:05 GMT

Hi,

To Understand Join Follow the below post.

http://community.qlik.com/thread/39177

Regards,

Nirav Bhimani