ghow many records fetch while reload ?

[#1]

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 ?????

[manideep78]

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.

[sushil353]

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

[#4]

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

];

[nirav_bhimani]

Hi,

To Understand Join Follow the below post.

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

Regards,

Nirav Bhimani