Options
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