It looks like you're new here. Sign in or register to get started.
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?
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.
If they're in tabs you might have to loop over them using the Read Excel operator and iterate over the sheet # parameter.
RapidMiner AI Hub
Automated Data Science
Training Classes & Certification
ML Algorithm Reference
Educational License Program