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
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
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)
)
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.