a newbie ques about importing excel file

amenaakhterchy

Hello

I am trying to import an Excel file into Rapidminer. However, this Excel file have mixed data format. For instance, a given column may contain some cells which are just numerical values, while some other cells are plain texts.when i am importing it showing a error "cannot get numeric value from a text file "  How should I  solve this problem ? 

 

thank you 

amena 

sgenzer

Ok I am assuming you got there by clicking "Add Data". If you go through the screens and get an error (mixed data), go back and force the import to polynominal on the columns causing trouble. Go back two screens ("Format your columns" and click on the drill down arrow. Go to "Change Type" and select polynominal. That should do the trick.