id in the excel spreadsheet getting replaced in rapid miner.

prdbalajiprdbalaji Member Posts: 2 Contributor I
edited December 2018 in Help
 

hi,

 

I have a sample data (.xlsx with 151K rows) for my rapid minder project and the unique ids in each row . Around 40000 rows are getting modified with the same number (2147483647) while adding the data (.xlsx)  in the rapid miner. I don't see these new id (2147483647) in the actual data .xlsx..only see them when i import it to rapid miner studio .. strange behaviour . Do you have any insigths on to whats going on ? I don't see an option to upload my sample dataset as .xlsx.

 

Please advise if anyone has a resolution to this basic problem.

 

Prad

Tagged:

Best Answer

  • kypexinkypexin Moderator, RapidMiner Certified Analyst, Member Posts: 291 Unicorn
    Solution Accepted

    Hi @prdbalaji

     

    The most likely caus for this issue is a numeric type overflow. 

    When you use READ EXCEL operator, go to 'Import Configuration Wizard' where you can manually choose data types for each column, and try to assign 'Polynomial' data type to a corresponding ID column from Excel file.

     

    Screenshot 2018-05-23 21.09.52.png 

Answers

  • lionelderkrikorlionelderkrikor Moderator, RapidMiner Certified Analyst, Member Posts: 1,195 Unicorn

    Hi @prdbalaji,

     

    To upload your .xlsx file : 

     - create a zip archive and share here in the forum.

     - post your file on a cloud repository (Google Drive for example) and share the link.

     

    Regards,

     

     

  • prdbalajiprdbalaji Member Posts: 2 Contributor I

    Thanks Valdimir!! Yes. that resolved the issue. 

     

    Prad

Sign In or Register to comment.