Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Selecting row after and before

Good afternoon, guys.   Is it possible for me to select a row after and before a specific set of filled rows ? i wish to build up gaps in my dataset in order to extract the correct datediff from my...
Need Help
Show and Tell
Tips and Tricks
v-zhenbw-msft's avatar
v-zhenbw-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi 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.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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