topic Re: what is concatenate ? in QlikView

what is concatenate ?

ksk278074 — Wed, 25 Nov 2020 16:16:04 GMT

Hi qlik team,

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

Thanking you team,

Re: what is concatenate ?

PabloTrevisan — Thu, 19 Jul 2018 18:57:21 GMT

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 ?

Re: what is concatenate ?

MindaugasBacius — Fri, 20 Jul 2018 05:17:19 GMT

I suggest you reading:

https://help.qlik.com/en-US/qlikview/12.0/Subsystems/Client/Content/Scripting/ScriptPrefixes/concatenate.htm

http://www.qlikfix.com/2010/12/09/merging-tables-concatenation/

http://www.learnallbi.com/concatenate-and-noconcatenate-in-qlikview-part-2/

Re: what is concatenate ?

PabloTrevisan — Fri, 20 Jul 2018 17:02:12 GMT

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.

Re: what is concatenate ?

BalaBhaskar_Qlik — Sun, 22 Jul 2018 07:08:17 GMT

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.

Re: what is concatenate ?

jonathandienst — Sun, 22 Jul 2018 15:14:54 GMT

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.

Re: what is concatenate ?

ksk278074 — Tue, 14 Aug 2018 17:21:51 GMT

Thanks for your answer

Re: what is concatenate ?

PabloTrevisan — Tue, 14 Aug 2018 19:18:18 GMT

Don't forget !