Discussion Board for collaboration related to Creating Analytics for QlikView.
can you please tell me how to use concatenate and which script i have use for concatenating 2 cols??
plese give me answer
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;
For concatenating tables:
LOAD * INLINE [Field_1,Field_2
LOAD * INLINE [Field_1,Field_3
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 ;
Please see this:
Understanding Join, Keep and Concatenate
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
sir how to use string functions in script??
where it can be placed??
dear priya ,
make this thread close and raise another one.
kotha question ga adagani and e question close cheyandi pls....
u can get in detail in qlikview help (f1)about string function.
You can close this thread if it helps.