id in the excel spreadsheet getting replaced in rapid miner.

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

Find more posts tagged with

AI Studio

Excel

Accepted answers

kypexin

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

All comments

lionelderkrikor

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,

kypexin

Hi @prdbalaji

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

Screenshot 2018-05-23 21.09.52.png

prdbalaji

Thanks Valdimir!! Yes. that resolved the issue.

Prad