Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello guys,
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:
Table_1:
LOAD * INLINE [Field_1, Field_2
A,User_1
B,User_2
];
Noconcatenate
Table_2:
LOAD
*,
(A & '-' & B) as C
From resident Table_1;
Drop table Table_1;
For concatenating tables:
ABC:
LOAD * INLINE [Field_1,Field_2
A,Name
B,Author
];
Concatenate
LOAD * INLINE [Field_1,Field_3
A,USA
B,UK
];
Hi Vishnupriya,
Lets you have 2 columns named WO & Date respectively. Now you want to concatenate this then you have to write like this :
Load
WO,
Date,
WO &'-'& Date as WODate
from xxx ;
Dear vishnu,
in qv we have 3 types of concatenation
1)concatenation
2)no concatenation
3)automatic conctenation
concatenation:
when we want to combine the tables if the fields are also not same then we go for this
noconcatenation:
when field are same and we want avoid the combining tables (due to unwantedly getting syn keys) we go for noconcatenation.
autoconcatenation:
when we have fields are same in both tables then qlikview it self goes for automatic concatenation.
ex:
load
*
from table1;
concatenation //noconcatenation//autoconcatenatio
load
*
from table2;
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.