5 Replies Latest reply on Nov 17, 2016 4:27 PM by saurabh.c.0

    Need help with Calculated field - Aggrea

    Ayan Chandra

      Hello Guys,

       

      I have a requirement. Need to create a calculated field out the data sample below. Below data shows per day basis say 5 jobs run and it captures start and end time. Now 11/03 is the current run date and all the jobs are not completed yet. I need to find out for each of the day ST_TIME for job A and END_TIME for JOB E (if job E is not complete, return NULL).

       

      Please help.

       

      Input Data.

       

      DATEJOB NAMEST_TIMEEND TIME
      11/1/2016AT1T51
      11/1/2016BT2T52
      11/1/2016CT3T53
      11/1/2016DT4T54
      11/1/2016ET5T55
      11/2/2016AT6T61
      11/2/2016BT7T62
      11/2/2016CT8T63
      11/2/2016DT9T64
      11/2/2016ET10T65
      11/3/2016AT11T71
      11/3/2016BT12T72
      11/3/2016CT13T73

       

      Expected Output:

       

      DATEST_TIMEEND TIME
      11/1/2016T1T55
      11/2/2016T6T65
      11/3/2016T11NULL