Column Expressions - IfThenElse: change 1 String value in case of Multiple Number options

Hi @rogerius1st

Hopefully the below example illustrates how to accomplish this. You’ll need to make sure you configure the Column Expression node to replace the existing column and change the data type to Number (integer).

if (column("StringOption") == "Option 1") 0
else if (column("StringOption") == "Option 2") 1
else if (column("StringOption") == "Option 3") 2
else if (column("StringOption") == "Option 4") 3
1 Like