need to concatenate multiple input columns into 1 output col
Moderators: chulett, rschirm, roy
need to concatenate multiple input columns into 1 output col
need to concatenate multiple input columns into 1 output column for each record. I am reading data from xml sources, after reading data the requirement is to concatenate the input columns of a record to 1 column and store. I feel using transformer stage variable is expensive. Please suggest any alternative. Thanks
-
- Premium Member
- Posts: 175
- Joined: Tue Oct 14, 2008 1:48 pm
Re: need to concatenate multiple input columns into 1 output
Use a Pivot stage and you can achieve it
Rajesh Kumar
-
- Participant
- Posts: 14
- Joined: Wed Nov 11, 2009 4:52 am
- Location: New York