how to get Max(DATE) using transformer

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

pxraja wrote:i.e., on Inlink.field01 as mentioned earlier.
The field that you showed having an example value of "jkdkal"? :?
-craig

"You can never have too many knives" -- Logan Nine Fingers
pxraja
Participant
Posts: 142
Joined: Fri Mar 14, 2008 10:22 am

Post by pxraja »

battaliou wrote:You can aggregate your sorted data on the key and choose "last" option for your date. This will function the same as a remove duplicate stage.
Hi all,

Thanks for your ideas, ray's idea is working and i ll try the above quote too
Post Reply