The Altair Community is migrating to a new platform to provide a better experience for you. In preparation for the migration, the Altair Community is on read-only mode from October 28 - November 6, 2024. Technical support via cases will continue to work as is. For any urgent requests from Students/Faculty members, please submit the form linked here
Read xlsx
Contributor II
Hello,
why changes rapidminer values which are read in xlsx???
For example 20110201 in excel and 2.0110201E7 in rapidminer????
i need the number in integer to change it to a date.
i have tried to save the datasheet in xls, there were no problems. But why?
why changes rapidminer values which are read in xlsx???
For example 20110201 in excel and 2.0110201E7 in rapidminer????
i need the number in integer to change it to a date.
i have tried to save the datasheet in xls, there were no problems. But why?
0
Answers
the numbers are exactly the same. But they are denoted in another way. 2.0110201E7 means 2.0110201 * 10 ^ 7 which is 20110201.
You can have a look here: http://en.wikipedia.org/wiki/Scientific_notation#E_notation
If you want to convert the number to date, try using the 'Numerical to Date' operator.
Best,
Nils