MULTIPLE ROWS TO SINGLE ROW

ajithaselvan · Post by **ajithaselvan** » Thu Jan 06, 2011 6:45 am

Hi,
Kindly help me to solve this in parallel job.

Input:
REC_TYPE,REC_COUNT, REC_SUM
C,3,1000
D,5,1500

Output:
REC_TYPE,C_REC_COUNT,C_REC_SUM,D_REC_COUNT,D_REC_SUM
T, 3, 1000, 5,1500

Thanks & Regards

jweir · Post by **jweir** » Thu Jan 06, 2011 7:59 am

Use a colon to concatenate the input links.

sajal.jain · Post by **sajal.jain** » Thu Jan 06, 2011 8:08 am

How do you arrive at 'T' in output & and what is criteria to merge... Are sets of 2 rows to be merged into one ?

ajithaselvan · Post by **ajithaselvan** » Thu Jan 06, 2011 8:22 am

In the output, REC_TYPE 'T' is the hardcoded value. Yes.2 input rows has to be merged into single row.

Thanks & Regards

ajithaselvan · Post by **ajithaselvan** » Thu Jan 06, 2011 8:23 am

Thanks jweir.
Can you please more specific?

Thanks & Regards

Ravi.K · Post by **Ravi.K** » Thu Jan 06, 2011 8:29 am

Maintain first record at Stage Variable by using @Inrownum.

Sv1--> If @Inrownum=1 Then inputfield1 Else Sv1
Sv2--> If @Inrownum=1 Then inputfield2 Else Sv2

Write the fields to target when @inrownum=2 by deriving all the attributes.

DSXchange

MULTIPLE ROWS TO SINGLE ROW

MULTIPLE ROWS TO SINGLE ROW

Re: MULTIPLE ROWS TO SINGLE ROW

Re: MULTIPLE ROWS TO SINGLE ROW