Convert Row's to Columns and Columns to Rows

[suri]

Hi,

I am new to this tool and I need some help.I want convert the Rows to Columns and Columns to Rows, I need to write Routine or is there any other way in Datastage.


Thanks
Suresh

[roy]

Hi,
Can you give a little example of what you need to do?

[KeithM]

You can use the pivot stage to convert columns to rows. Converting rows to columns is a little harder. There have been numerous posts on that topic in this forum. Do a search on 'vertical pivot'.

[rasi]

In version 7 you have Row Splitter and Row Merger. The splitter reads one row and splits a string into number of columns. The Row Merger merges all the columns to one single string in specified format.

As Keith said you can use Pivot to convert columns to rows. and Row Splitter to convert rows to columns.

Thanks
Siva