Manipulate attribute into a number

KNIME Analytics Platform
1

Hallo!
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?

image

2

Hi @ganieaku

What is your expected output in this case? “manipulate the attribute into a number” is somewhat vague.

3

Yeah. I want to manipulate the attribute into a classifiable number. Thanks for corrected @ArjenEX

4

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,
Raffaello

1 Like
5

@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

2 Likes
6

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