Firs not null cell

beacc

Dear all,

I want to add a column where I have the first not null value. Something like this:

The thing is that the value will depend of the file and probably will not be at the same position, for example the first not null cell is in row 5 but then is possible that the first is in the row 3.

Thank you all

JamesCharnley

@beacc you can filter out non-null rows and use the sample tool to find the first instance of a non-null when it's sorted by RecordID, which you can then append to all rows as in your requested output.

appendfirstnonnull.yxmd