DSXchange

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

Use a Pivot stage and you can achieve it

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

use column export stage