need to concatenate multiple input columns into 1 output col

[yogeshhd]

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

[kittu.raja]

Use a Pivot stage and you can achieve it

[chulett]

It's not a pivot, just a concatenation. And there really shouldn't be any extra 'expense' with doing it in a stage variable.

[sridinesh2009]

use column export stage