Column Expression AND OR with conditional

[salazachou]

Hi everyone, I am using the Column Expressions node to make a conditional using other columns. Basically, I want to change COLUMN_A by “A” when 3 conditions are meet (see image).

I was using this expression but is not working

if(length(string(column("ID"))) == 10 & (left(string(column("ID")),1) === "8" | left(string(column("ID")),1) === "9") & column("COLUMN_B") === "Z" )  {
    "A"
    }
else{
    column("COLUMN_A")
    }

I am also attaching the workflow.

Cheers

Column Expressions Question.knwf (12.1 KB)

[izaychik63]

Column expression uses Java syntax. So, no “===” just “==” equation.

[salazachou]

Hi @izaychik63 thank you for the reply, I did this modification

if(length(string(column("ID"))) == 10 & (left(string(column("ID")),1) == "8" | left(string(column("ID")),1) == "9") & column("COLUMN_B") == "Z" )  {
    "A"
    }
else{
    column("COLUMN_A")
    }

But it is not working

Thank you

[izaychik63]

I checked

@salazachou

length(string(column("ID")))

is 13 not 10.