Altair RISE

A program to recognize and reward our most engaged community members

Nominate Yourself Now!

Import Data Mismatched

When I was trying to import data from excel, and the id of the data shown in the RapidMiner is not matching the ones in excel. I've tried to change the type, however, it doesn't work.. Any idea why this is happening and how to solve the problme? Thanks! ID in excel.png ID in RapidMiner.png

Find more posts tagged with

AI Studio

Accepted answers

zprekopcsak

I did a quick test and this is actually an Excel data representation issue. If you create a CSV file including the following three lines:

id
802334127760489980
624764543663741950

and open it in Excel then it will show it as

id
802334127760489000
624764543663741000

Tested with Excel 2016 for Mac.

All comments

qwertz2

Please post your excel file and the XML code of your process.

Thomas_Ott

Is your excel column using Rounding?

hongxiangy

Thanks. Below is the XML code and I've attached part of the excel file.

@qwertz2 wrote:

Please post your excel file and the XML code of your process.

xml code.png

datatype.png

hongxiangy

Hi Thomas, I don't think the numbers are rounded in the excel file. I'm guessing the number is out of the range of the Rapidminer's "real number type"? Any idea how to fix the problem? Thanks a lot.

excel datatype.png

zprekopcsak

I did a quick test and this is actually an Excel data representation issue. If you create a CSV file including the following three lines:

id
802334127760489980
624764543663741950

and open it in Excel then it will show it as

id
802334127760489000
624764543663741000

Tested with Excel 2016 for Mac.