Min() Max() from a Sequential file

karthi_gana · Post by **karthi_gana** » Thu Oct 29, 2015 5:26 am

All,

I have a file with header, detail & footer.

Detail record is stored in a different file along with row_num. I want to get the min(row_num) and max(row_num) from the file without using aggregator stage. is it possible?

Thanks
Karthik M

qt_ky · Post by **qt_ky** » Thu Oct 29, 2015 5:34 am

I suppose you could ensure it is sorted and use stage variables instead of an aggregator...

ray.wurlod · Post by **ray.wurlod** » Thu Oct 29, 2015 8:52 am

Count the lines and subtract 2 to give the max. Use 2 for the min. This assumes one header and one trailer line.

karthi_gana · Post by **karthi_gana** » Thu Oct 29, 2015 8:17 pm

Incase If I have multiple headers in the file, I think this logic will not give expected result.