Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
Not applicable

FORCED CONCATENATION


When using forced concatenation with multiple key fields, how is it determined by which key field(s) the new data is concatenated to the correct records?

Tags (2)
1 Reply
Not applicable

Re: FORCED CONCATENATION

Hey Alexander concatenation is done wherever there are common field names between two tables. If the field doesn't exist the value will be null. Concatenation doesn't need key fields(they come into play only in Joins).

Ex:

ABCD
1US12323.4
2CAD2343.3
3MEX3451.2
4Aus4560.9

ACZ
1123alpha
2234beta
4100gamma

Result after concatenation:

ABCDZ
1US12323.4-
2CAD2343.3-
3MEX3451.2-
4Aus4560.9-
1-123-alpha
2-234-beta
4-100-gamma