Joins In Qlikview

[rahulsingh12]

I have 3 tables namely A,B,C

A has 15 records

B has 189,190,900 records

C has 789 records

When I join B and C with A  using a left join I get a very huge volume of data in A (around 170,000,000) which is not correct.

Is it something that I am doing with the joins.

As because my understanding of joins is that left join should only give me 15 records as in table A.

regards,

[prma7799]

Please share some sample data and expected output.

Or you can try like this

A:

Load * from Table A;

Left Join (A)

B:

Load * from Table B;

Left Join (A)

C:

Load * from Table C ;

Thanks

[rahulsingh12]

The data volume is huge so I won't be able to show that volume of data here.

I just wanted to know by any chance do I get more records in A after left joining with B and C ?

Regards.

[prma7799]

No Chance ..

Can you share your script?

[stabben23]

Hi Rahul,

I would say that table A and C is dimenssiontables and B is a Fact(transaction) table.

Why do you need to join these? in Qlikview you are able to keep them separated With an Association between them.

Just find the common key in A and B, and in C and B.

Another way is to use applymap to get Values from A and C into B.

It feels that if you want to join you should use LEFT JOIN (A) instead..

[Anil_Babu_Samineni]

First join the B & C and then get and club the data for A

[vinieme12]

Read this post

Understanding Join, Keep and Concatenate