Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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.

1 Solution

Accepted Solutions
vamsee
Specialist
Specialist

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

View solution in original post

8 Replies
vamsee
Specialist
Specialist

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.

Anonymous
Not applicable
Author

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

vishsaggi
Champion III
Champion III

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
Specialist
Specialist

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
Anonymous
Not applicable
Author

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
Contributor II
Contributor II

Hi Jonathan

The answers are correct. Please mark as answered.

vamsee
Specialist
Specialist

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.

Anonymous
Not applicable
Author

Thank you once again.