2 Replies Latest reply: Oct 23, 2018 8:06 AM by Kingsley Hoare RSS

    Dates Help in backend

    Mahitha M

      Hi Experts,

       

      Can any one please help me on below requirement.

      I have the source like below

       

      Source:

      Load * Inline [

      App,ID,Startdate,Enddate

      Banking,4586A,05/10/2018 00:00:00,08/10/2018

       

      Crime Analytics,5793B,25/07/2018 00:00:00,

      Crime Analytics,8794B,13/07/2018 00:00:00,

       

      HR,48632E,12/09/2018 00:00:00,13/09/2018

      HR,58632E,05/08/2016 00:00:00,

      HR,68632E,09/06/2018 00:00:00,

       

      Service,8632O,03/09/2018 00:00:00, 06/09/2018

      Service,86321,01/10/2018 00:00:00, 04/10/2018

      ];

       

      In the below input we have 8 rows. Here I need to keep only the rows where both startdate and enddate is not blank  by using backend script.

      Please help me on this.

      Please find the below attached app.



      Thanks in advance


      Input

      input.png

      Expected output


      expected output.png