Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
ksk278074
Contributor III
Contributor III

what is concatenate ?

Hi qlik team,

       i am new in qlik view so you can explain the concatenate concept

         Thanking you team,

7 Replies
PabloTrevisan
Partner
Partner

Hi Sivakumar,

Concatenate appends the rows of one table to another. Concatenate never merges any rows. The number of rows in a concatenated table is always the sum of the rows from the two input tables.

look this two tables:

tbles.jpg

Now let's apply a concatenate function

TABLE1:

LOAD * FROM Table1;

concatenate(TABLE1)

LOAD * FROM Table2;

res.jpg

It help's you ?

PabloTrevisan
Partner
Partner

Don't forget !


When applicable please mark 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. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.

balabhaskarqlik

Like Union in SQL, Concatenate is used in Qlikview to create new columns by concatenating tables.

Concatenate defined in 3 ways in Qlikview.

AutoConcatenate - QIX engine forms Autoconcatenate, By Similar fields from different tables.

Force Concatenate - When there is no common fields in different tables.

No Concatenate - When not to combine data from different tables & make it as Individual tables.

jonathandienst
Partner
Partner

I would put it a little differently.

If the fields are all the same name (and remember that field names are case sensitive), then the second table will auto-concatenate. You can also force concatenation by using concatenate keyword ahead of the LOAD. Or you can prevent autio-concatenation using the NoConcatenate keyword ahead of the LOAD.

As you can see, its a little different to a SQL union, which only works when the fields are identical name and type.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
ksk278074
Contributor III
Contributor III
Author

Thanks for your answer

PabloTrevisan
Partner
Partner

Don't forget !


When applicable please mark 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. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.