"RM 5.1.1.does not read Excel files"

MuehliManMuehliMan MemberPosts:85Guru
edited May 2019 inHelp
Dear all,

I updated RM to version 5.1.1. and suddenly my processes did not work anymore. The first error occured with the Read EXCEL operator, where A0 as cell range was not accepted. I guess A1 is working, but I did not check it thoroughly. Secondly the attributes where not read on the fly and thus the Rename operator caused numerous warnings.

Did anyone else encounter this behaivior? MEanwhile I downgraded to version 5.1.0.

Cheers,
Markus
Tagged:

Answers

  • landland RapidMiner Certified Analyst, RapidMiner Certified Expert, MemberPosts:2,531Unicorn
    Hi,
    细胞范围A0当然不工作:Excelstarts counting on 1. The question is: Did you enter this or was there an error in the automatic translation of a pre 5.1 process?

    Greetings,
    Sebastian
  • MuehliManMuehliMan MemberPosts:85Guru
    Hey Sebastian,

    I think you already guessed it right. It was the value assigned by importing an "old" RM 5.0 workflow. So maybe the value A0 was set as the default value, if it has not been set before?

    Do you have any comments on the fact, that the attributes' name was not preloaded and available for other Operators (e.g. Set Role).
    Cheers,
    Markus
  • landland RapidMiner Certified Analyst, RapidMiner Certified Expert, MemberPosts:2,531Unicorn
    Hi,
    I have fixed the issue with the counting, this should work with the next version.

    The MetaData are not loaded any longer if you don't set them using the wizard. It simply takes to long to always parse the complete excel file during the meta data propagation. That's why we have introduced the repository in the first place, please use it instead to always have fast and proper meta data.

    Greetings,
    Sebastian
Sign InorRegisterto comment.