Page 1 of 1
concatenate two column values to generate single column
Posted: Thu Nov 20, 2008 1:14 pm
by nirdesh2
How to concatenate two column values to generate single column without using Transformer.
I am doing a lookup and returning 2 column and now i want to concatenate these 2 column and store the output in one column.
Please help me.
Re: concatenate two column values to generate single column
Posted: Thu Nov 20, 2008 1:47 pm
by tehavele
I think Transformer is the best way for concatination as per my knowledge , unless there is something other trick.
Re: concatenate two column values to generate single column
Posted: Thu Nov 20, 2008 1:50 pm
by kittu.raja
nirdesh2 wrote:How to concatenate two column values to generate single column without using Transformer.
I am doing a lookup and returning 2 column and now i want to concatenate these 2 column and store the output in one column.
Please help me.
Use the funnel stage. where you will the 2 columns data into single column
Re: concatenate two column values to generate single column
Posted: Thu Nov 20, 2008 10:55 pm
by tehavele
I dont think funnel will be useful here.Funnel is like a union expression in sql.
Posted: Thu Nov 20, 2008 11:10 pm
by Romy
you can try using column export stage. The Column Export stage exports data from a number of columns of different data types into a single column of data type string or binary.
Posted: Thu Nov 20, 2008 11:31 pm
by bi_fujitsu
Use the concatenation operator :
ColA:ColB in the trasformation of your target column
Posted: Fri Nov 21, 2008 4:46 am
by nirdesh2
Romy wrote:you can try using column export stage. The Column Export stage exports data from a number of columns of different data types into a single column of data type string or binary.
It helped me...
Thanks a lot...