Extract Blocks of Data from an Excel File

barry_bowden
barry_bowden New Altair Community Member
edited November 2024 in Community Q&A

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

  • Telcontar120
    Telcontar120 New Altair Community Member

    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.

     

     

  • Thomas_Ott
    Thomas_Ott New Altair Community Member

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

Categories