5 Replies Latest reply: Jan 23, 2017 1:50 PM by Manish Kachhia RSS

    Hi Team, I need to create new table(Expressions) from a existing table

    Siddharth Sharma

      H Team,

       

      So, Here is sample data

         

      IdErrorTypeDateStatus
      1A1/1/2017Unresolved
      1A1/2/2017Resolved
      1A1/3/2017Unresolved
      1A1/4/2017Unresolved
      1A1/5/2017Resolved
      1A1/6/2017Unresolved
      1A1/7/2017Resolved
      1B1/7/2017

      Unresolved

      As you can see , Id 1 has 2 type of errors, but here error has multiple entries, it opened on 1/1/2017 but get resolved on 1/2/2017, it again reopened on 1/3/2017 and then resolved on 1/5/2017 and again it get reopened on 1/6/2017 and then resolved on 1/7/2017

       

      I want a table from this flat file that will below result

       

           

      IdErrorTypeStart DateResolve DateStatus
      1A1/1/20171/2/2017Resolved
      1A1/3/20171/5/2017Resolved
      1A1/6/20171/7/2017Resolved
      1B1/7/2017 Unresolved

       

      So I have created 2 new fields, Start Dare and Resolved Date, So ErrorType A was opened 3 times so 3 rows with open date(Start Date) and ResolvedDate.