no need to. concatenate means creating one table out of two. There is no need to change names in columns. QlikView will put same name columns together and the rest with null values were no common column name exists. For example
Table 1
columns A, B
Table 2
columns A, C
if you concatenate, the result will be :
Table 3
columns A, B, C
with null values in column C for table 1 rows and with null values in column B for table 2 rows
Concatenate
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. A concatenation is in principle the same as the SQL UNION statement, but with two differences: first that Concatenate prefix can be used no matter if the tables have identical field names or not; and secondly that no removal of identical records are made.
The syntax is:
concatenate [ (tablename ) ] ( loadstatement | selectstatement )
Examples:
Concatenate LOAD* FROM file2.csv;
Concatenate SQL SELECT * FROM table3;
tab1:
Load * from file1.csv;
tab2:
load * from file2.csv;
.. .. ..
Concatenate (tab1) load * from file3.csv;
