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:
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:
firstvalue(Czas_start) as Czas_start,
LastValue(Czas_stop) as Czas_stop
; Drop Table KADRY_podzial;