Column Expression node user error ?

Hi
I am using the Column Expression to change a cell depending on the value of a different cell.
Repalce Column = yes Output Column = Siglum

if (column(“Accounting Element”) == ‘1111’) ‘ABCD’
else column(“Siglum”);

This works fine, however if i add a second expression with the same expectations
if (column(“Accounting Element”) == ‘2222’) ‘ABCD’
else column(“Siglum”); Knime creates a new Column ‘Siglum (#1)’

I am sure this is just simple user error but if anyone can point me at where i am going wrong that would be appreciated

Mark

Hi @mgirdwood

If I read it correctly, this should work:

if (column("Accounting Element").equals("1111") || column("Accounting Element").equals("2222")) {
    "ABCD"
} else {
    column("Siglum")
}

Tip: try to use the formatting option on the forum, that makes it easier to read :wink:

3 Likes

Thanks Arjen, I will have to look at the syntax build up as I thought i tried using OR :slight_smile:

1 Like

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