Forum Discussion
Selecting row after and before
Community SupportHi Anonymous ,
Sorry for that we cannot understand your requirement clearly. Do the third and fourth columns is the column need to added? What is the logic to add those columns?
Does the third column copy the second column’s value? Does the fourth column copy the first column’s previous value? And why the third column and fourth column have some blank?
Could you please split the raw data of your sample and the expected result into two tables so that we can understand it easier?
Best regards,
Community Support Team _ zhenbw
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Another example:
this one is better, as you can see i have a lot of yellow rows that need to be filled, because the dtInicio of the previous row is equal to dtFim of the next row until the orange colored rows (as you can see, here the continuation ends and the cycle is broken)