Multi Row formula Like Alteryx

Do we have a node in Knime, which works same as Mutli Row Formula in Alteryx ?

Hey @Rishabh,

not directly, but you could do it with a combination of the Lag Column node and the Math Formula node.

This is nicely described in our book From Alteryx to KNIME (Page 21). The book is free of charge and will give you useful information on how to do things in KNIME compared to Alteryx.

Cheers,

Julian

4 Likes

Hi @Rishabh,

I also come from Alteryx… hope this can help you and/or you can help update:

2 Likes

Not widely known yet, but they added it with the latest version into the Column Expressions Node!

Edit- Looks like you beat me to it @Alejandroc!

2 Likes

@iCFO @Alejandroc make sure to activate the window on the spaced settings tab … :slight_smile:

2 Likes

Advanced settings …

1 Like

We knew what you meant. :+1:

1 Like