🎉 🎉 RAPIDMINER 9.10 IS OUT!!! 🎉🎉

Download the latest version helping analytics teams accelerate time-to-value for streaming and IIOT use cases.

CLICK HERE TO DOWNLOAD

Extract Blocks of Data from an Excel File

barry_bowdenbarry_bowden Member Posts: 1 Contributor I
edited June 2019 in Help

I have an exported Excel file showing data by employee. I need to pull this block for each employee and get a specific value.

 

I searched the forums and did not see anything similiar.

 

How can I go about doing this?

Answers

  • Telcontar120Telcontar120 Moderator, RapidMiner Certified Analyst, RapidMiner Certified Expert, Member Posts: 1,625   Unicorn

    If the data is always in the same place (row or column) then you can use the parameter in the "Read Excel" operator to specify the sheet location containing only the data you need.  But sometimes that gets complicated, and the easier thing to do is simply import the entire sheet and then once the data is in RapidMiner, use Filter and Select to isolate the data you need.

     

     

    Brian T.
    Lindon Ventures 
    Data Science Consulting from Certified RapidMiner Experts
  • Thomas_OttThomas_Ott RapidMiner Certified Analyst, RapidMiner Certified Expert, Member Posts: 1,760   Unicorn

    If they're in tabs you might have to loop over them using the Read Excel operator and iterate over the sheet # parameter.

    Telcontar120
Sign In or Register to comment.