0 Replies Latest reply: Jul 3, 2018 3:54 AM by Adam Gałęza RSS

    How to join the Time field with two statements in one row?? - help

    Adam Gałęza

      Hi everyone!

       

      I have a problem with getting the first and last time fields where each of this field have exactly that same other fields.

      My situation is like here:

      example_problem.png

      I had this problem before but with only dates.

       

      Mainly this table had time in one field like u had last column here. i split states by BeaconState field in two columns and next concatenate the tables. What i can to do next to get the numbered fields in one row.? This is all information in table what i have.

      i try to use firstvalue and group by other fields like ImieNazwisko, BeaconName (first column), BeaconState and Czas.

       

      At the moment my last modified rows from Script:

       

      NoConcatenate

      KADRY_czas:

      Load distinct

          BeaconName,

      BeaconStatus,

      Czas,

      ImieNazwisko,

          firstvalue(Czas_start) as  Czas_start,

          LastValue(Czas_stop) as Czas_stop

      Resident KADRY_podzial

      Group By

      BeaconName,

      BeaconStatus,

      Czas,

      ImieNazwisko

      Order By

      ImieNazwisko,

      Czas,

      czas_start_row,

      czas_stop_row,

      BeaconStatus,

      BeaconName

      ; Drop Table KADRY_podzial;