Hi @Ironzem
you can try by sorting first in one direction and comparing with previous record.
table2:
load
if(Token <> Previous(Token) or number_date <> Previous(number_date) ,1,0) as flag1,
*;
load
Floor(date#(TImestamp_field,'dd-mm-yyyy hh:mm')) as number_date, //to have date without time
*
resident table1
order by Token, TImestamp_field asc;
drop table table1; //table1 is your previous table
and then sorting in the other way around and comparing again with previous.
table3:
load
if(flag1=1 or Token <> Previous(Token) or number_date <> Previous(number_date),1,0) as FinalFlag,
*
resident table2
order by Token, TImestamp_field desc;
drop fields number_date,flag1; //as are not needed anymore
drop table table2; //previous sorted table, also not needed anymore
Hope it works for you
Please, remember to mark the thread as solved once getting the correct answer
Best,
