Concatenating is the process of putting two tables together.
When two tables have exactly the same fields, concatenation is done automatically by Qlikview. So the following source tables will result in one QlikView table:
This can be avoided by using the Noconcatenate statement
If two tables do not have exactly the same fields, concatenation is still possible, but has to be made explicit through the Concatenate statement
Without further instructions, the QlikView script will concatenate the table with the last created table.
The resulting Table1 has three fields: A; B; and C. Of course there are no rows with data for A, B and C filled out.