topic Re: Use of Joins and Forced and Automatic Concatenation in QlikView

Use of Joins and Forced and Automatic Concatenation

Anonymous — Tue, 12 Sep 2017 08:20:53 GMT

Can anyone tell me any scenario where we use join and where we use forced and automatic concatenation.

Thanks

its_anandrjs — Tue, 12 Sep 2017 08:25:58 GMT

There some points for the JOINs, Concatenation.

1. Where you have table with unique key fields in the table you can use Joins (Left,Right,Inner,Outer,Join).

2. Concatenation used where you have many fields same in two or more tables then you use concatenation with flag fields in the table.

3. If one or more table has same field structure than you get automatic concatenation and if you use concatenation it is forced concatenation.

Anonymous — Tue, 12 Sep 2017 10:04:13 GMT

1. When You have Two table with Unique Field

So by Using the Concept of Primary Key and Foreign key

You can Used JOINS

(Left , Right , Inner , Cross)

2. Concatenation will be Automatically called

When we have TWO Tables and all the fields of Both the Table are present with Same Name

Regards

Tahemas Momin

Anonymous — Tue, 12 Sep 2017 11:21:02 GMT

Thanks for the help.

If possible, Please give an example for each.

its_anandrjs — Tue, 12 Sep 2017 11:28:36 GMT

Thanks read some of this with attachments take a time to learn about all this docs.

Regards

Anand