Altair RISE

A program to recognize and reward our most engaged community members

Nominate Yourself Now!

convert nominal to numerical problem

I want to convert nominal values into numeric, I tried the dummy coding but a column is generated for each value there is, then I use unique integers and I get like an order number but not what the number actually is, all I want is one column with the numeric values, any ideas?

Find more posts tagged with

AI Studio

Accepted answers

sebastian_gonza

I used a guess type and worked, thks anyways

All comments

phellinger

Hi,

is this a question related to Radoop. I am just asking because of your other recent question... If yes, then probably "Type Conversion" operator is the one you are looking for.

If it is Studio, then "Parse Numbers" operator looks promising.

Best,

Peter

lionelderkrikor

Hi @sebastian_gonza,

Have you try to :

- set your concerned attributes as numeric in the import configuration wizard (step 4 / 4).

AND/OR

- use the Parse Numbers operator on your concerned attributes.

I hope it helps,

Regards,

Lionel

sebastian_gonza

I am extracting a sample from a hive data set throught a retrieve and then store it in my local repository, is there a way to do it during the workflow?

sebastian_gonza

Here is the workflow and the data I am using, if you have an idea please let me know

thks

nominal to numeric.zip

sebastian_gonza

I used a guess type and worked, thks anyways