problem in Nominal to numerical operator

Hello Everyone
I have a data contains numbers but its type is “ nominal “ and I need to convert it to numerical for further processing..

When I use “ Nominal to numerical operator “ , it encode the data and I don’t need that bc my data is numerical ONLY its type ..

So Anyway to keep the data the same but only changing the type ??

Please Help ..

Find more posts tagged with

AI Studio

ETL + Data Prep

Accepted answers

All comments

varunm1

Hello @omarnj

You can change the attribute type when you are importing data, if you alreay imported then you can follow as below.

If the data is in RM repository, right-click on your data and click on edit as shown in below image.

Once you do that you will get a "Data Editor" window, here go to the attribute you need to change then right click and click on "Modify attribute".

Image: https://us.v-cdn.net/6030995/uploads/editor/in/k3p4rir36364.png

Now in "attribute type" you can select "Numeric" from drop down. Then click "Apply" and then click on Save icon as shown in below image. Now, your attribute data type is changed to numeric. You need to drag and drop the data set into process again after saving it.

Image: https://us.v-cdn.net/6030995/uploads/editor/yq/xj0r9ki3tiiy.png

Hope this helps.

tftemme

Hi @omarnj

You can also use the Parse Numbers operator. It changes a nominal attribute to a numerical numbers and tries to parse the nominal values to actual numbers.

Best regards,
Fabian