The RapidMiner community is on read-only mode until further notice. Technical support via cases will continue to work as is. For any urgent licensing related requests from Students/Faculty members, please use the Altair academic forum here.
"Problem with Filter Example Range"
![Nick_Coldhand](https://us.v-cdn.net/6030995/uploads/defaultavatar/nCCNNSPK1YM69.jpg)
![](https://s3.amazonaws.com/rapidminer.community/vanilla-rank-images/contributor-16x16.png )
I'm using Excel sheets with Date as ID, and found this strange behaviour, everytime the example set goes through the "Filter Example Range" operator:
1. If Date is in Excel "Date" format (MM/DD/YYYY), every filtered example is dated 1/0/1900
2. If Date is in Excel "Number" format (# days from 1/1/1900), this doesn't happen and all is well
3. If the sheet is imported in my repository, and the "Retrieve" operator is used to read it, every filtered example is dated 1/0/1900, regardless of the date format when the sheet was imported.
1. If Date is in Excel "Date" format (MM/DD/YYYY), every filtered example is dated 1/0/1900
2. If Date is in Excel "Number" format (# days from 1/1/1900), this doesn't happen and all is well
3. If the sheet is imported in my repository, and the "Retrieve" operator is used to read it, every filtered example is dated 1/0/1900, regardless of the date format when the sheet was imported.
Tagged:
0
Answers
Hi there,
I deal with time series a lot and suspect that the answer is more probably outside RM. Running the following gets some data from an SQL database, samples some into an .xls file, and reads that file. No probs encountered. However.... .
http://en.allexperts.com/q/Excel-1059/Cell-references.htm
In the result screen, the example set is always OK.
But if I try to use "Write Excel" after "Filter Example Range", the written file will show all the examples dated 1/0/1900 (in cases #1 and #3 of my OP). Thus, I'm not sure if the problem is in "Filter Example Range" or in "Write Excel"
thank you for this hint. Seems to be a bug in the write excel operator, I will take a look.
Greetings,
Sebastian