The Altair Community is migrating to a new platform to provide a better experience for you. The RapidMiner Community will merge with the Altair Community at the same time. In preparation for the migration, both communities are on read-only mode from July 15th - July 24th, 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.
Options

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

  • Options
    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

  • Options
    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,

     

     

  • Options
    prdbalajiprdbalaji Member Posts: 2 Contributor I

    Thanks Valdimir!! Yes. that resolved the issue. 

     

    Prad

Sign In or Register to comment.