2 Replies Latest reply on May 25, 2020 5:08 AM by Dharmendra Reddy Nara

    How to do Consolidation with most recent not null column?

    Dhanya Chandran New Member

      Hi all,


      I am trying to consolidate a record in Informatica 9.6.0 Developer tool. Here we faced a situation that we need to consolidate our record based on a given field which is Most Recent Update Date field. Now if the record with most recent update field contains a null, the value should be checked with other records if we found a value in that column, the final record will fill the value from there, an example is as follows


      Suppose

       

      Cluster ID Name PhoneNumber TaXID Last_Update_DAte
      1    Dan    44567  6789    26-10-2010
      1    Dhan  12346              25-10-2011
      1    Danny 11245              25-10-2012
      1    Dan     78934 11246  11-11-2011

       

      Then the result will be


      Cluster ID Name PhoneNumber TaxID Last_Update_DAte
      1 Tammy 78934 11246 25-10-2012

       


      How can we acheive this in consolidation transformation. Please help with this scenario, we havent find any function here in consolidation based on this case..


      Thanks and Regards

      Dhanya