string manipulation error

KNIME Analytics Platform
#1

Hi,

I have one column with churn data (Bin1, Bit2) meaning "0" and '1". When I try to change the strings names (Bin1, Bit2) to "0" and '1" it gives me a syntax error " insert";" to complete BlockStatetment". When I only make the renaming transformation from Bin1 to "0" it does correctly but it also transforms Bin2 to "02" (see attached sceenshot)

 

Michel

#2

Hello,

if you want to use String Manipulation Node, you can take one replace statement and nested it within another replace statement:

replace(replace($ChurnIndicator_Binned$, "Bin1", "1"), "Bin2", "0")

 

#3

It worked.

 

thanks