Options

importing large number of records from excel

z_meftahiz_meftahi Member Posts: 1 Contributor I
edited August 2019 in Help
I want to have the operation of clustering for an excel file with about 2 fields (with no formula) and about 400,000 records, but the data cannot be imported. To be more precise, the third step of importing data from excel file cannot be passed :-\
I need guidance how to solve this problem
Tagged:

Answers

  • Options
    homburghomburg Moderator, Employee, Member Posts: 114 RM Data Scientist
    Hi z.meftahi,

    right now the maximum capacity of the excel import is limited to a value smaller than 200.000 rows. To workaround this problem you may export your data from MS Excel to csv file format and use the csv input operator or wizard.

    Cheers,
    Helge
Sign In or Register to comment.