Options

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?

Tagged:

Answers

  • Options
    Telcontar120Telcontar120 Moderator, RapidMiner Certified Analyst, RapidMiner Certified Expert, Member Posts: 1,635 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
  • Options
    Thomas_OttThomas_Ott RapidMiner Certified Analyst, RapidMiner Certified Expert, Member Posts: 1,761 Unicorn

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

Sign In or Register to comment.