topic Re: Joins In Qlikview in QlikView

Joins In Qlikview

rahulsingh12 — Tue, 27 Jun 2017 03:46:59 GMT

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 — Tue, 27 Jun 2017 04:06:39 GMT

Please share some sample data and expected output.

Or you can try like this

Load * from Table A;

Left Join (A)

Load * from Table B;

Left Join (A)

Load * from Table C ;

Thanks

rahulsingh12 — Tue, 27 Jun 2017 04:58:21 GMT

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 — Tue, 27 Jun 2017 04:59:47 GMT

No Chance ..

Can you share your script?

stabben23 — Tue, 27 Jun 2017 05:25:42 GMT

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 — Tue, 27 Jun 2017 05:51:54 GMT

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

vinieme12 — Tue, 27 Jun 2017 07:29:40 GMT

Read this post