Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to select max() in ODI 12c

John305Feb 20 2017 — edited Feb 21 2017

Hi everyone ,

here's a viw of my job , in the Join 3 , i will have 3 rows for each ID , so i need only to keep the row with max( date ) , how can i proceed ? Thank you !! ( btw :i am new in odi ^^ )

pastedImage_0.png

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 21 2017
Added on Feb 20 2017
2 comments
1,419 views