DSXchange

How to convert rows in to column in 7x Parallel

Please help me

- Rams

use pivot stage

import the source data,
give the target column names, then what ever the columns want to make rows,, map those columns to under required trg col
the data bill be added in row format

it will not possible in pivot stage, we need to convert rows in to column

It is possible. This is precisely what the Pivot stage does.

Hi Ray,

thanks for you reply

Following is my requirement.

Source
=====

Col
===
1
2
3
4

target
=====

Col
===
1,2,3,4


source records count will vary, it will not same always.


thanks,
Rams

Hey Man it is possible with pivot stage..
i worked on that..
u try with the logic above what i mentioned ,
how many columns there maybe no problem it will convert..
you try and then tell me

are you doing this based on any key olumn?

All the records in a column has to be combined into a single record using the stage variables in transformer.

1. Create a dummy key column, sort and partition on that column.
2. In transformer use stage variables, one will store the current record and the stage variable will append the records.
e.g.
Input Column = Stagevariable
Stagevariable:stagevariable1=stagevaribale1
3. Use Remove duplicate and retain the last record.