Hi there, I’m new to Knime and I would like some advice on moving some of my spreadsheet workflow to Knime.
In my one sheet I have a formula that subtracts the 11th cell in a column from the second and puts the result in its own column.
The formula is =(C11-C2)
Is there a way to do this for an entire column of data and put the results in another column without using Python or R? I’m trying to move as much of my Sheet workflow into Knime because right now my Knime data goes into Google Sheets and then gets read from Google Sheets again to be processed.
The answer to your question is yes.
But based on your input it is impossible (for me at least) to tell you how. So it would be helpful for me and other Forum visitors if you provide some sample data that show what your data looks like at the start and what you expect after C11-C2 is executed.
You have to be aware on the Advanced settings’ tab to set Enable multi-row access with a larger window size than the reference row distance + activate Use ‘null’ option
