Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
binimanjoe
New Contributor II

How does QlikView perform Concatenation?

Hi all,

Please, I need somebody to explain how QlikView would concatenate Table B with Table A.  The two tables are shown in the image below.  Do note that the order of the columns are not exactly the same in both tables.

Concatenate.PNG

Besides, when we say:

CONCATENATE [Table XX]

LOAD …. ;


What is the order of operation - is it result of LOAD statement CONCATENATE [Table XX] or

[Table XX] CONCATENATE result of LOAD statement ?

What would be the name of the table resulting from the CONCATENATE operation?

Thanks you for your patience.

Tags (2)
1 Solution

Accepted Solutions
vamsee
Valued Contributor

Re: How does QlikView perform Concatenation?

Blank records are created in Table A.

Like

LOAD

          Product

FROM TableA;

concatenate

LOAD

          Customer,

          Product

From TableB;

o/p:

CustomerProductSource
1TableA
2TableA
3TableA
4TableA
1235TableB
2346TableB
3457TableB
4568TableB
8 Replies
vamsee
Valued Contributor

Re: How does QlikView perform Concatenation?

Hi Jonathan,


Qlik concatenates (appends new rows) to the first table based on column names. Hence, they do not have to be in the same order of Table A.

Coming to your second question Result of Load statement of Table B is appended to TableA. (Test it with a where clause in TableB)

The result would be TableA itself.

binimanjoe
New Contributor II

Re: How does QlikView perform Concatenation?

Thanks for the response.  So, what happens when some columns in table B do not have matching names in table A?

vishsaggi
Esteemed Contributor III

Re: How does QlikView perform Concatenation?

If you use CONCATENATE final table will have this new Column with Nulls in TableA for this column and values for tableB. If you do not use CONCATENATE keyword synthetic keys will be formed.

vamsee
Valued Contributor

Re: How does QlikView perform Concatenation?

Blank records are created in Table A.

Like

LOAD

          Product

FROM TableA;

concatenate

LOAD

          Customer,

          Product

From TableB;

o/p:

CustomerProductSource
1TableA
2TableA
3TableA
4TableA
1235TableB
2346TableB
3457TableB
4568TableB
binimanjoe
New Contributor II

Re: How does QlikView perform Concatenation?

Thank you all for these responses.  I really appreciate them.  The illustration makes it look easy. Nevertheless, I am just a beginner in QlikView.  I am not sure whether the answers are correct or not.  So, I leave it for those who are well grounded in QlikView to determine whether or not the answers are correct.

abednego
New Contributor II

Re: How does QlikView perform Concatenation?

Hi Jonathan

The answers are correct. Please mark as answered.

vamsee
Valued Contributor

Re: How does QlikView perform Concatenation?

No problem Jonathan. Glad that we could help.

Furthermore, you would be able to find more details about concatenation on Qlik help.

https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/LoadData/concatenate-tab...

/*****************************************************************/

Please close the thread by marking the appropriate replies as CORRECT https://community.qlik.com/docs/DOC-14806. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution.

binimanjoe
New Contributor II

Re: How does QlikView perform Concatenation?

Thank you once again.