Convert Numeric into Nominal


Happy to contact you again. I would like to convert one column which has 1 or 0(numirical) into nominal ie. active or inactive. it is possible ? is there any node for this ?

best regards


You can use the "Rename" node and change the type of the column to StringValue (without actually renaming it).


rename node changes only Column ID, Not replacing Active for 1 and inactive for 0.

best regards


What about the Binner?

Binner is the way I would do it.

Column->Convert & Replace->Number (Integer) to string node and then  string replacer node , again in column nodes.

How about a simple java snipet, perhaps performance is not great though?

return $columnName$==0?"active":"inactive";

Use the option to rename the column and set the return type="string"