Real time scenario on join/concatenate usage

[pradeep92]

‌

Hi , I understood very well on how join and concatenate works but when is the situation to be used in real time ?

Also is the outer join and concatenate is the same if there are no matching records ?

[its_anandrjs]

In your data model suppose the two tables are exactly same or maybe few fields only different then go for concatenate.

1. When to use outer join (let assume in your two tables few fields are common or may be composite keys are there then you have to go for the Outer join also concatenate works)

2. If more fields are common or may be exactly same then it is concatenated.

3. In qlik when you reload and due to qlik engines if found two fields in table are same then it is auto concatenate.

[pradeep92]

Yeah. As per my understanding, when there are so much of matching fields between tables then go for concatenate else join. But how does the data look like ?

[pradeep92]

Any other answers please to understand  much better ?

[Anil_Babu_Samineni · Accepted solution]

Please read carefully and do practical - Understanding Join, Keep and Concatenate

[its_anandrjs]

Data is treated as a single table then and available in one table also you can differentiated it with the flag fields to identify data is for which table.

[pradeep92]

Thank you !

[its_anandrjs]

Some of this you can read also for your help on your topics.

Different Join Functions in Qlikview

Some Qlikview Joins,Keep,Concatenation and Applymap best documents