The Altair Community is migrating to a new platform to provide a better experience for you. In preparation for the migration, the Altair Community is on read-only mode from October 28 - November 6, 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

id in the excel spreadsheet getting replaced in rapid miner.

prdbalajiprdbalaji Member Posts: 2 Learner III
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 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 

    -- 
    Vladimir
    http://whatthefraud.wtf

Answers

  • lionelderkrikorlionelderkrikor 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 Learner III

    Thanks Valdimir!! Yes. that resolved the issue. 

     

    Prad

Sign In or Register to comment.