2 Replies Latest reply on Aug 29, 2018 1:50 PM by jay.tiscavitch

    Teradata Issue: Dttm

    jay.tiscavitch

      Hello,

       

      I'm having issues with tracking numbers having a one to many relationship.

      What I am trying to accomplish is to only pull back the Dttm for the event that occurred first. For the example below, it would be tracking event (Concat) "AJZA".

      I've tried the min function, but that did not work as each line is still distinct.

       

      I only want the first tracking event to return, even if a tracking number has multiple tracking events, with different event codes.

       

      Any help would be greatly appreciated!!

      DTTM Issue.jpg

       

      Thanks!

      Jay