i am also faceing same problem . my dataset contains mixed formats . when i am importing excel file . it showing error "cannot get numeric value from a text file . " how can i solve this ?
As Marius suggested originally, the best solution is to set the data type to polynominal during the Excel import, which will then allow both numeric and non-numeric characters and all the data will be imported. Once all the data is in RapidMiner, you can then convert the numerical data using "Parse Numbers" and also decide how you want to deal with the non-numerics (simply have missing values, impute missing values, etc.).