Find more posts tagged with
Sort by:
1 - 5 of
51
You can omit certain columns from being read in by deselecting them as part of the import wizard. And if you have a few header rows at the top they can also be omitted. But there isn't a way to skip individual cells, you would have to deal with those after import within RapidMiner using some other logic.
Hi,
There is actually a wizard for the Read Excel operator as well (first button in the parameters of the Read Excel operator). In the second step, you can select data in the table or define ranges in the box at the top. However, it looks like you can only define ranges of neighboring cells / columns and not skip columns for example.
As Brian said, you can always deal with this after import (i.e. first read everything and then have a small prep process removing the unwanted cells or columns).
Other than that, I would not know how to achieve this. I do not think that either the import wizards or any of the operators use the information if a column is hidden or not...
Best,
Ingo
Ingo
No, as Ingo said, you are better off simply importing the whole sheet and then removing the unwanted elements later by using Select Attributes and Filter Examples or other similar approaches.
Sort by:
1 - 1 of
11
Hi,
There is actually a wizard for the Read Excel operator as well (first button in the parameters of the Read Excel operator). In the second step, you can select data in the table or define ranges in the box at the top. However, it looks like you can only define ranges of neighboring cells / columns and not skip columns for example.
As Brian said, you can always deal with this after import (i.e. first read everything and then have a small prep process removing the unwanted cells or columns).
Other than that, I would not know how to achieve this. I do not think that either the import wizards or any of the operators use the information if a column is hidden or not...
Best,
Ingo
Ingo