The RapidMiner community is on read-only mode until further notice. Technical support via cases will continue to work as is. For any urgent licensing related requests from Students/Faculty members, please use the Altair academic forum here.
Why is the new Rapid Miner 9.4 removing some content for my excel document after importing.
![AmosGH](https://us.v-cdn.net/6030995/uploads/defaultavatar/nCCNNSPK1YM69.jpg)
![](https://s3.amazonaws.com/rapidminer.community/vanilla-rank-images/learner-16x16.png )
I was importing an excel file into the new RAPID MINER 9.4 repository but after loading it, it removed most of my content before the hashtag.
My old Rapid miner was not giving me this issue. Help![Image: https://us.v-cdn.net/6030995/uploads/editor/7b/loxbavuvmcsc.png](https://us.v-cdn.net/6030995/uploads/editor/7b/loxbavuvmcsc.png)
My old Rapid miner was not giving me this issue. Help
![Image: https://us.v-cdn.net/6030995/uploads/editor/7b/loxbavuvmcsc.png](https://us.v-cdn.net/6030995/uploads/editor/7b/loxbavuvmcsc.png)
![Image: https://us.v-cdn.net/6030995/uploads/editor/1c/aq5i7p9sdpwo.png](https://us.v-cdn.net/6030995/uploads/editor/1c/aq5i7p9sdpwo.png)
Tagged:
0
Comments
There is in deed a bug in Read Excel operator when there are return carriages (\r) and jump to the line (\n) in your initial excel file.
I already described this bug in a previous thread.
After experimentations and "a little luck", the workaround here is to replace the "return carriages" and the "jump to the line" by .... nothing via the operator Replace just after Read Excel.
The process in attached file.
PS : @sgenzer . I suggest to push this thread in "Bug Report" if the RM developpers are not already aware of this "bug".
Thanks you,
Regards,
Lionel
A priori, actually there is only this workaround (via the Replace operator).
There is no permanent solution actually, that's why Scott submitted this to RapidMiner's development team : in order to find a permanent solution (fix the problem).
Regards,
Lionel
The content is still there, it's just visible when you hover over the field. What is the expected behavior? We don't change the content when reading a file. I would consider this to be a feature request.
Regards,
Andras
I think there is still a problem with the Read Excel operator associated with Execute Python operator when there is text in an example set :
When a such example set enters in the Execute Python operator, it seems that some examples are "splitted" in several examples.
In entry of the Execute Python, and so after the Read Excel operator i have the following exampleset :
After the Execute Python operator , the example set becomes an example set with 122 examples : (The Execute Python does nothing)
I think this behaviour is linked to the "carriage return" and "line feed" because if we put a Replace operator with the setting (described in my previous post) just before the Execute Python operator, all is allright.
You can reproduce this behaviour by running the process in attached file (Enable/disable the Replace operator to see the difference).
The Excel file (data) is provided by @AmosGH in a previous post.
Regards,
Lionel
OK, thanks you for your reply.
Regards,
Lionel