I have an attribute of type string data. As seen below. Because he has a name that has so many kinds. But from the whole data, some have the same name. I want to manipulate the attribute into a number. Does Knime have nodes that can help solve my problem faster?
What is your expected output in this case? “manipulate the attribute into a number” is somewhat vague.
Yeah. I want to manipulate the attribute into a classifiable number. Thanks for corrected @ArjenEX
Hello @ganieaku ,
if you mean that KOSONG = 1, MTS AL = 2 etc. etc. you could follow these steps:
- use a remove duplicate filter on your row
- then a counter generator, so that each single value is given a value
- finally, use a joiner node to assign the numeric value to your input column.
Hope it helps.
Have a nice day,
@ganieaku you could use the:
and convert strings to numbers and store the ‘dictionary’ to re-use it later
There are more advanced methods also
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.