Hi, Just a simple one. I have tried to use KAI to check a syntax error in an IF Contains statement using the Expression Node. However back in Knime it still doesnt like it - Please can I check if i missed something below
I could see that there is a Square bracket “]” instead of round bracket )" in above formula
Can you try this ?
if (contains(column(“Organisation”), “#”)) { column(“Siglum Level4”) } else { column(“Organisation”) }
@MartinDDDD
Thanks Martin, That works in the legacy expressions node I can use this node of course, Thanks.
I was trying to use the new Expressions node and the syntax in that node is different - $ instead of Column, [ instead of (
Using the “click” to choose columns etc but adding {} where it would be in the legacy version =