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
Convert Row's to Columns and Columns to Rows
Moderators: chulett, rschirm, roy
Hi,
Can you give a little example of what you need to do?
Can you give a little example of what you need to do?
Roy R.
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
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
As Keith said you can use Pivot to convert columns to rows. and Row Splitter to convert rows to columns.
Thanks
Siva