Search found 1 match

by samder76
Tue Dec 22, 2009 3:54 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How can I get the minimum date in the aggregator?
Replies: 10
Views: 6867

Instead of using an aggregator stage to find a minimun date, you can use a "Remove Duplicates" sorting your date data with the "ascending" option (when you specify your partitioning). Finally, you have just to retain the first row (duplicate to retain : first). It works well with...