Spliting two colums into two rows

[sansan]

Hi,

I'm facing some problem of spliting two colums (header, detail) of files into two rows.

Following is my sample records:

Input File is like below:

Header , Details
A, B

I would like to have the Output like:

Header
A
Details
B

Is it possible to get the output like above?

Thanks a lot,
san san

[KeithM]

You can use the pivot stage to split columns into rows. It has been covered here many times before. Just do a search on 'pivot' or 'horizontal split.'

[dsxdev]

You can check the RowSPlit Stage in server canvas.
Pivot Stage will convert columns to rows.

[martin]

Yes....U Can Do This


======>TX=====>Pivot=====>Out

Concatnate Transformer[TX] Input Clumns Into One Output Column
TX
(Input) (Output)

col1
col2 "Header" (col1)
col3 col1:col2:col3:col4:col5:col6 (col2)
col4 "Trailer" (col3)
col5
col6

Pivot
(Input) (Output)

col1
col2 col1,col2,col3
col3

Try This GoodLuck