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
MULTIPLE ROWS TO SINGLE ROW
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 75
- Joined: Mon Jul 12, 2010 4:11 am
- Location: Chennai
MULTIPLE ROWS TO SINGLE ROW
Ajitha S
-
- Participant
- Posts: 11
- Joined: Sat Mar 13, 2010 12:00 am
Re: MULTIPLE ROWS TO SINGLE ROW
How do you arrive at 'T' in output & and what is criteria to merge... Are sets of 2 rows to be merged into one ?
Major GungHo
-
- Participant
- Posts: 75
- Joined: Mon Jul 12, 2010 4:11 am
- Location: Chennai
Re: MULTIPLE ROWS TO SINGLE ROW
In the output, REC_TYPE 'T' is the hardcoded value. Yes.2 input rows has to be merged into single row.
Thanks & Regards
Thanks & Regards
Ajitha S
-
- Participant
- Posts: 75
- Joined: Mon Jul 12, 2010 4:11 am
- Location: Chennai