The data I have looks like the table shown in the appendix 'Current format'. I want to come to the result shown in the appendix 'Needed result'.
So I need some form of grouping based on the ID column. And also a sorting based on the BOTTOM_DEPTH or based on the DBK column.
Within each group, the first row needs to get a top depth of zero. All following rows need to get the BOTTOM_DEPTH value of the row above.
Once you have sorted into the correct order, you can use the Adjacent Feature option in an Attribute Creator with a conditional statement to get the correct values. If the ID does not match the ID of the feature above, set the TOP_DEPTH to 0, otherwise set it to the bottom depth of the previous feature (feature[-1])
Once you have sorted into the correct order, you can use the Adjacent Feature option in an Attribute Creator with a conditional statement to get the correct values. If the ID does not match the ID of the feature above, set the TOP_DEPTH to 0, otherwise set it to the bottom depth of the previous feature (feature[-1])
Thank you for the quick reply @ebygomm! It indeed gives me the result I need :-)