Manual "Category to Number" Mapping

Just discovered KNIME, and I love it so far. However, I ran the “Category to Number” feature on one of my transformed test datasets and it ended up mapping the “successful” entries to 0 and “failed” to 1.

Is there a way to manually adjust these mappings? So far I can’t find a straightforward way to do it. I tried using the RuleSet Editor and feeding the PMML model into the “Apply” version of the node, but that didn’t do anything.

Thanks!

1 Like

Hi @poitryu
You can do this manually using the “Rule Engine”. See attached workflow.
category to number.knwf (6.4 KB)

2 Likes

Awesome! Thank you so much. So my attemp with the PMML RuleSet editor wasn’t too far off I suppose… now I’ll just have to find a way to consolidate in my head why simple one-hot or label encoding can be done with “Column Manipulations”, whereas this approach is a “Row Manipulation”. Small difference, maybe.

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.