I can't get the

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?

Find more posts tagged with

AI Studio

Accepted answers

Prentice

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

All comments

Prentice

IngoRM

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