RapidMiner

Read Excel - imported cell range - just one column

SOLVED
Wisdom logo Registration now open for RapidMiner Wisdom Americas | New Orleans | October 10-12, 2018   Learn More
Learner III imke
Learner III

Read Excel - imported cell range - just one column

Hello,

I have a large Excel document and want to do text mining with one of the columns. So I use Read Excel for it and now I want to set the imported cell range for let's say the column 'E'. I know it sounds stupid but I don't know how to do this.

I tried the 'E:E' Version I know from Excel VBA but that does not work. For sure I could write for example 'E1:E10' but my Table is going to get more entrys and I do not want to correct it all the time.

So is there a possibility to import just one column?

Thank you

Imke

4 REPLIES
RM Staff RM Staff
RM Staff

Re: Read Excel - imported cell range - just one column

Hi,

 

E:E should do it.

 

Best,

Martin

--------------------------------------------------------------------------
Head of Data Science Services at RapidMiner
Learner III imke
Learner III

Re: Read Excel - imported cell range - just one column

Hello Martin,

I'sorry but it does not. I am getting this text and I don't know why because I wrote E:E as you can see on the right.

unbenannt_4.png

Thank you for your help

Imke

RM Staff RM Staff
RM Staff
Solution

Re: Read Excel - imported cell range - just one column

Hi,

interesting. In the Import Wizard it does work.

 

Please try: E1:E10485776

 

It seems to automatically prune it to the max rows.

 

BR,

Martin

--------------------------------------------------------------------------
Head of Data Science Services at RapidMiner
Highlighted
Learner III imke
Learner III

Re: Read Excel - imported cell range - just one column

Thank's a lot! That works.Smiley Very Happy