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.
Hey, i'm sorry for taking so long to answer. i Was sick the last few days and wasn't able to use the computer.
So, about the issue in hands. it's as the following image:
Everytime time the number 387 appears in the column idParada, i want the column SETUP MARK to show me dtinicio continuously (dtinicio of the previous row is equal to the dtFim from the next) as it is shown in the example. BUT, in some situations, it does not fill the rows, as you can see in the yellow ones.