I can't get the

Prentice
Prentice New Altair Community Member
edited November 5 in Community Q&A
I have an Excel file which has a lot of cells with a lot of text in it. The text in these cells are often separated by an "Alt+Enter", meaning it looks something like this:

First line of text in a cell
Second line of text in a cell

Unfortunately, the "Read Ecxel" operator doesn't read the whole cell. It only reads: "First line of text in a cell" and it ignores the rest of the lines. 
I've already tried to wrap the text in Excel with no result.
Is there anyway I can get RapidMiner to read the whole cell?
Tagged:

Best Answer

  • Prentice
    Prentice New Altair Community Member
    Answer ✓
    Already got it. It turns out that when it shows the exampleset, it only shows the first line, but the other lines are in there as well. The only thing is, is that it is not displayed in the exampleset

Answers

  • Prentice
    Prentice New Altair Community Member
    Answer ✓
    Already got it. It turns out that when it shows the exampleset, it only shows the first line, but the other lines are in there as well. The only thing is, is that it is not displayed in the exampleset
  • IngoRM
    IngoRM New Altair Community Member
    edited March 2019
    Yeah, that's on purpose.  a) we wanted to keep the line breaks in the data but b) now having larger or multi-line rows.  In fact, there are some technical reasons for that since a table in the RapidMiner UI has a maximum pixel height (don't ask :-))
    But it should show the full content of a cell as a tooltip when you hover over that cell for some time.
    Cheers,
    Ingo