add +1 to previous value

[madac]

hello,

I have a table that is of the form:

how can I fill in the empty rows in the “code” column with the following values? i.e. to remain the same code “ABC_” but no. to be +1 compared to the previous one

[gonhaddock]

Hello @madac
You can use ‘Column Expressions’ node:

join(
    "ABC_"
    , right(column("nr") - 8, 4)
)

BR

P.S.- If referred to a previous rows, the right format would be as follow; however you won’t fill the upper tail of the list. Both column expressions would be needed and a rule engine on whether apply one or the other, aiming top fulfil with the upper tail.

join(
    "ABC_"
    , right(column("nr" - 8), 4)
)