How to convert rows in to column in 7x Parallel
Please help me
- Rams
convert rows in to column
Moderators: chulett, rschirm, roy
Re: convert rows in to column
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
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
Regards
Sankar
Sankar
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 40
- Joined: Mon May 11, 2009 12:19 am
- Location: Madurai
are you doing this based on any key olumn?
Last edited by priyadharsini on Fri Mar 25, 2011 3:29 am, edited 1 time in total.
-
- Participant
- Posts: 40
- Joined: Mon May 11, 2009 12:19 am
- Location: Madurai
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.
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.