Skip to main content

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])

Capture


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])

Capture

Thank you for the quick reply @ebygomm​! It indeed gives me the result I need :-)


Reply