What is the different between concat and concatenate

[princyal]

Hi,

I am new in Qlikview Please, anyone explains what is the different between concat and concatenate with a simple example

[marcus_sommer · Accepted solution]

concat() is an (string) aggregation-function like sum() and concatenate adds a table to another table (like an union in sql).

- Marcus

[Brett_Bleess]

Marcus always does an awesome job, and I always seem to be trampling all over his posts, but I figured some official Help links might not hurt on this one for anyone else that comes across it! 🙂  Hope you don't mind too much Marcus.

Concat:

http://help.qlik.com/en-US/qlikview/November2018/Subsystems/Client/Content/QV_QlikView/Examples%20of...

Concatenate:

http://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/Scripting/Script...

Marcus was dead on in his description, I just know some folks want to see the official documentation as well.

Cheers,
Brett

[WillW]

Concat combines field values into a string with a delimiter, while Concatenate appends rows from one table to another. Concat is for text, Concatenate is for tables, as simple as that. Much like how the symbol of pi π represents a simple yet profound mathematical constant.