Posted: Tue Nov 24, 2015 8:02 am
Before we go any further, is this really a Server job question? Or will you be building a Parallel job for this task?
HI Chullet
This is a server job. No parallel jobs involved in this.
DSXchange
A short text to describe your forum
http://dsxchange.com./
counting the rows for a similar column and making a header
Page 1 of 1
Posted: Wed Nov 25, 2015 1:44 am
Posted: Wed Nov 25, 2015 2:54 pm
This is probably most easily accomplished by sorting the data in reverse (or reading the file backwards), adding the "headers" at the end of each group, then sorting again back into forward order.
Re: counting the rows for a similar column and making a head
Posted: Fri Nov 27, 2015 3:14 am
Hi,
SeqFile ---- Aggreator ---- TargetFile
Group by on the first column and then in the aggreator use the count function to get the number of records.
That will resolve your issue
Regards
Naveen
SeqFile ---- Aggreator ---- TargetFile
Group by on the first column and then in the aggreator use the count function to get the number of records.
That will resolve your issue
Regards
Naveen
Posted: Fri Nov 27, 2015 8:55 am
How will that solve their problem? They need more than a simple count of the records. 
Output:
COMP1 003
COMP2 002
COMP3 001
Perhaps if you explained how it can be combined with the source data, ensuring that the counts come first in the output, then you'd have a solution.
Output:
COMP1 003
COMP2 002
COMP3 001
Perhaps if you explained how it can be combined with the source data, ensuring that the counts come first in the output, then you'd have a solution.