concatenate two column values to generate single column

[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.

[tehavele]

I think Transformer is the best way for concatination as per my knowledge , unless there is something other trick.

[kittu.raja]

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

[tehavele]

I dont think funnel will be useful here.Funnel is like a union expression in sql.

[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.

[bi_fujitsu]

Use the concatenation operator :
ColA:ColB in the trasformation of your target column

[nirdesh2]

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...