The Altair Community is migrating to a new platform to provide a better experience for you. In preparation for the migration, the Altair Community is on read-only mode from October 28 - November 6, 2024. Technical support via cases will continue to work as is. For any urgent requests from Students/Faculty members, please submit the form linked here

Extract Blocks of Data from an Excel File

barry_bowdenbarry_bowden Member Posts: 1 Learner II
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

  • Telcontar120Telcontar120 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
  • 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.