Multi row formula in knime.

[ArjenEX]

Hi @Ankisha

Do you happen to be a colleague of Hammy? That data looks very familiar

multi row formula

Hi team, facing problem in middle of workflow and the problem is i have to use expression with unique rows and lag column(i mean -1 row. ) so basically i have scenario where some data has duplicate value but with unique identifier ( there are also duplicates also with unique ids) and i have to merge two column before grouping it to get unique data and than i have to use some expression like:- {IIF(isnull([Row-1:RecordID]), 1,[Row-1:RecordID]+1)} i had used lagged function to get -1 records …

There are some pointers in the above topic related to group loops and column expressions that should get you in the right direction.