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
Hi Priya,
Concatenate tables like Union in Oracle.it will append the records from both tables like vertival merging.
Tab1:
Load * from tab1;
Concatenate
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
Load A,
B,
A&' '&B as New_Column( this is field concatenation)
from table;
hope this will help to you.
Hi Priya,
Just goto ---> qlikview Help der all the string functions are der.just go through that if you dont understand any function just post it in community.
der you can find all the string and numeric and time functions