Solved: Re: Use of Joins and Forced and Automatic Concaten... - Qlik Community

Anonymous · ‎2017-09-12

Hi

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

Thanks

its_anandrjs · ‎2017-09-12

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.

its_anandrjs · ‎2017-09-12

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 · ‎2017-09-12

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 · ‎2017-09-12

Thanks for the help.

If possible, Please give an example for each.

its_anandrjs · ‎2017-09-12

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

Regards

Anand

Use of Joins and Forced and Automatic Concatenation