Multi Row formula

Hi All,
I’m ttying to transfer a workflow from alteryx to knime.
I’m having some issues in recreating the Multi Row formula node (Alteryx name) on knime.

Capture2
the input are columns: Material Ref. and Diff and the output that i would like to obtain is the column Diff shiftata

Do you have any suggestion of how to replicate it on knime?

Hi @Pietro_Zaza

I believie the lag column + math formula nodes should do the trick

2 Likes

Other option could be column expressions node
br

1 Like

Indeed it would

1 Like