Options

Upper Case values getting filtered during import of Excel data [SOLVED]

jnick8855jnick8855 Member Posts: 2 Contributor I
edited November 2018 in Help
Hi All,

Brand new here, I have tried to read proper etiquette for posting questions, this one should be a layup for someone I think. I have an excel column field that has a mixture of UPPER case values and lowercase values. Only the lower case values are making their way into my wordlist. Somehow all Uppercase values are getting filtered during the import or read process. A value like this,"Air Canada  455 Ottawa (ON) - Toronto Pearson (ON)" will be read by RM no problem but a value like this "VISA INFINITE PURCHASES]" will not get imported through the Read Excel process. Maybe I am missing a character setting or need a different operator. Any thoughts or links would be great.

Thanks,

JN

Tagged:

Answers

  • Options
    sgenzersgenzer Administrator, Moderator, Employee, RapidMiner Certified Analyst, Community Manager, Member, University Professor, PM Moderator Posts: 2,959 Community Manager
    hmm that's weird.  Have not seen that before.  My first effort would be to go into "data set meta data information" (turn on "advanced parameters") and mandate that the column be brought in as polynominal.  Also check that your encoding is correct (again an advanced parameter).

    Scott
  • Options
    jnick8855jnick8855 Member Posts: 2 Contributor I
    Thanks for the reply Scott. The encoding was incorrect...user error!

    Cheers,

    Jeff
Sign In or Register to comment.