Hi friends Does anyone knows how I can use the “IN” operator in the “Column Expressions” node? For example: I usually create a lot of Else conditions “Else IF”, for the same results. But, if I create only one Else IF using de IN operator (similar to SQL) = IF ....... else if (left(column("Texto cabeçalho documento"),2) == "FR") { "SemConfronto_Msaf_FreteFatura" } else if (left(column("Texto cabeçalho documento"),2) == "OE") { "SemConfronto_Msaf_FreteFatura" } = Like this Below … else if (left(column(“Texto cabeçalho documento”),2) $ FR_OE) { “SemConfronto_Msaf_FreteFatura” } In some programming languages, the IN operator seams to be this sign “$” , and the list of items separated by underline. How would it be inside “Column Expressions” node?

See discussion here [image] arraycontains in if condition in column expression node KNIME Analytics Platform Hi @izaychik63 , since it has multiple conditions with different columns, i don’t think string manipulation is suitable, as it supports only single column changes, correct me if i am wrong. Regards, Pavan.

Column Expressions IN Operator

KNIME Analytics Platform

izaychik63 June 4, 2023, 9:56pm 6

See discussion here

1 Like