for joining 2 fields we can add one resident load for the table we loaded and can drop the table:
LOAD * INLINE [Field_1, Field_2
(A & '-' & B) as C
From resident Table_1;
Drop table Table_1;
Lets you have 2 columns named WO & Date respectively. Now you want to concatenate this then you have to write like this :
WO &'-'& Date as WODate
from xxx ;
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