topic Re: Why we use concatinate function in qlikview? in QlikView

Why we use concatinate function in qlikview?

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

Hi All ,

Please help

Re: Why we use concatinate function in qlikview?

sibin_jacob — Fri, 03 Aug 2018 11:12:41 GMT

Concatenate function is for appending two tables.

If it is having same column name and same column count, it will concatenate automatically.

If you want to append two tables, which is having different column names,

you need to use concatenate function in between two tables load statement.

It is for forcefully concatenate two tables.

Please refer the below link for more details.

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

Re: Why we use concatinate function in qlikview?

sarvesh — Fri, 03 Aug 2018 11:25:10 GMT

Hi Aretha,

If two tables that are to be concatenated have different sets of fields, concatenation of two tables can still be forced with the Concatenate prefix. This statement forces concatenation with an existing named table or the latest previously created logical table. An automatic concatenation occurs if two tables have the same field names.

Syntax:

Concatenate[ (tablename ) ] ( loadstatement | selectstatement )

A concatenation is in principle the same as the SQL UNION statement, but with two differences:

The Concatenate prefix can be used no matter if the tables have identical field names or not.
Identical records are not removed with the Concatenate prefix.

If your problem has been shortout, please mark correct and helpful and close this thread.

Regard's

Sarvesh Srivastava

Re: Why we use concatinate function in qlikview?

MarcoWedel — Fri, 03 Aug 2018 20:26:53 GMT

please close your open threads

thanks

regards

Marco

Re: Why we use concatinate function in qlikview?

BalaBhaskar_Qlik — Sat, 04 Aug 2018 11:07:32 GMT

What's your expectation on Concatenate?

Refer these:

Concatenate appends the rows of one table to another. The number of rows in a concatenated table is always the sum of the rows from the two input tables. Here's what our sample data will look like after Concatenate. It happens even when the tables have different number of columns. It differs from both Join and Keep command, as it does not merge the matching rows from two tables into one row.

https://www.tutorialspoint.com/qlikview/qlikview_concatenation.htm

https://community.qlik.com/thread/39177

Re: Why we use concatinate function in qlikview?

qlikviewwizard — Mon, 13 Aug 2018 10:12:49 GMT

Concatenate

Now let's look at Concatenate. 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. Here's what our sample data will look like after Concatenate.

CONCATENATE (Table1) LOAD * RESIDENT Table2;

Key	A	C
1	A1
1		C1
2	A2
2		C2
3	A3
4		C4

Rows with like Key values are not merged together. The rows from Table2 are simply appended to Table1. Because the tables have different fields, rows will have null values for the fields from the "other" table.

Re: Why we use concatinate function in qlikview?

BalaBhaskar_Qlik — Mon, 13 Aug 2018 14:22:01 GMT

If you got the answer, please close the thread.