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.
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)
Another example, but with some data that should not be considered.
orange: should not be there
yellow: it's okay to have this sequence, because it starts with code idParada 387