Concatenate tables like Union in Oracle.it will append the records from both tables like vertival merging.
Load * from tab1;
Load * from tab2;
But here two tables having same structure.
concatenation: if you dont have same structure use concatenate keyword.if you have same structure qlikview itself it will concatenate each other by default.
noconcatenation: if you don't want concatenation use no concatenate keyword
Column concatenation means if you have A and B columns then create new column like this
A&' '&B as New_Column( this is field concatenation)
hope this will help to you.
in qv we have 3 types of concatenation
when we want to combine the tables if the fields are also not same then we go for this
when field are same and we want avoid the combining tables (due to unwantedly getting syn keys) we go for noconcatenation.
when we have fields are same in both tables then qlikview it self goes for automatic concatenation.
make sure pls close the thread by making apporopriate answer