string manipulation error

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

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")

 

It worked.

 

thanks