I have a table with date and time stamp columns as string or integer values. The integer date values occur multipal times but chronologically, see screenshot.
Now I want to replace the values in “shift” column using a counter starting with 1 and Count 1 up until the “shift date” value i not the same as in the previous row. In this case the “Replace Counter” have to start at 1 again.
If this helps, I can change the data type of the “shift” column to Integer or Long.