I have some trouble to sort a table by date (timestamp) and compare two columns in a script
I have a table like this :
I want to show the data like this :
To do so, I must load data from a database, sort by date (with timestamp !) and concatenate TextA & TextB in the good order (date) and without double, group by Identifier
I have tried to :
Resident Table_Temp_From_database ORDER BY Date ASC;
But the "ORDER BY" doesn't seem to work
Then I try to concatenate with concat
Concat(TextA, '-' ),
Resident Class_sort GROUP BY Identifier;
But as the table is not sort by date the concatenation is not good..
Moreover, my problem is that I must compare if previous.TextB = current.TextA before the concatenation to have (A-B-C-A) and not (A-B-B-C-C-A)... But as my table is not sort by date I don't know how to do so...