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.
concatenate two column values to generate single column
Moderators: chulett, rschirm, roy
Re: concatenate two column values to generate single column
I think Transformer is the best way for concatination as per my knowledge , unless there is something other trick.
Tejas
-
- Premium Member
- Posts: 175
- Joined: Tue Oct 14, 2008 1:48 pm
Re: concatenate two column values to generate single column
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
Rajesh Kumar
Re: concatenate two column values to generate single column
I dont think funnel will be useful here.Funnel is like a union expression in sql.
Tejas
-
- Premium Member
- Posts: 46
- Joined: Tue Mar 20, 2007 3:30 am
- Location: India