Column Expression error for multiple row function

KNIME Analytics Platform
1

ME2O-out.xlsx (23.2 KB)

[Column Expression with multiple line Error.knwf|attachment](upload://wwo15FTjoXCILZ5ZsDNB7jplULA.knwf) (10.3 KB)
...
How can slove the function {column("Stock Qty",-1)} error after excute it the column expression? I can use node "Lag column", but error with function  {column("Stock Qty",-1)} in the node column expression. Please find the source file (speadsheet) and thr work flow.
2

Hello @CNYANBILL,

and welcome to KNIME Community!

Seems like you haven’t managed to upload your workflow. Please give it another try.

Br,
Ivan

3

Column Expression with multiple line Error.knwf (10.3 KB)

Dear Ivan,
Thanks for your reminder, Could you veirfy whether it’s successful for uploading.

Br,
Bill
Column Expression with multiple line Error.knwf (10.3 KB)

4

Hello @CNYANBILL,

you have to go to Advanced tab of Column Expressions node and enable multi-row access.

And yes, you have successfully uploaded your workflow. Twice this time :smiley:

Br,
Ivan

3 Likes
5

Thanks a lot! it works.

1 Like
6

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.