Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi qlik team,
i am new in qlik view so you can explain the concatenate concept
Thanking you team,
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:
Now let's apply a concatenate function
TABLE1:
LOAD * FROM Table1;
concatenate(TABLE1)
LOAD * FROM Table2;
It help's you ?
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.
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.
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.
Thanks for your answer
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.