Union column

Hi

I have variable number of columns, i.e. col1,col2,....coln. How can I loop though all columns and stack all value into one new column or ,say, col1? This would be similar to union/union all in SQL.

Many thanks

Wei

If I understand correctly, all you need to use is the the collection column node or the new column aggregator node. In fact, if the column numbers vary, the column aggregator is best as you can then take advantage of the dynamic column handling available in the node using the force inclusion/exclusion options.

Simon.

Thanks, collection column node serve the need.