Barry Harmsen over at Qlikfix put together a nice post about the CONCATENATE script function, and that got me onto other posts that clarify and give examples on the proper use of this powerful feature. From Barry’s post:
One of the subjects I often see new QlikView developers struggle with, especially those without prior database experience, is merging data from different tables. In this series of two posts I will explain how to use the CONCATENATE and JOIN prefixes to bring together data from multiple tables. Simply put, the CONCATENATE prefix lets you add rows to a previously loaded table, while the JOIN prefix lets you add columns to a previously loaded table.
Understanding Join and Concatenate: The Qlikview script functions JOIN and CONCATENATE can sometimes be used to tackle the same problem, but there are important differences that should be understood.
And finally, QlikviewMaven did a nice post on NOCONCATENATE. Don’t let Qlikview auto-concatenate for you — put the power back in your own hands!
This is a mistake I make every once in a while and it always puzzles me for a few minutes before I figure out what happened. In the loadscript, if you load data from several sources and use exactly the same field names then QlikView will automatically concatenate the data from the second source onto the table created for the first source. It does this unless you specify the keyword NOCONCATENATE.