🎉Community Raffle - Win $25

An exclusive raffle opportunity for active members like you! Complete your profile, answer questions and get your first accepted badge to enter the raffle.
Join and Win

Problem with import of excel file

User: "LeMarc"
LeMarc
New Altair Community Member
Updated by Jocelyn
Hello,

I tried to import data from an excel file. However theres always an error message which says

"Failed to parse the content in column 'sales':
Cause: unpearsable real numbers:"-" "

Within the feature sale there are some values of 0.

Does anyone have a suggestion how to solve?

Thank you!

Find more posts tagged with

AI Studio
Excel
Sort by:
1 - 5 of 51
    User: "sara20"
    sara20
    Banned
    @LeMark,
    Hello

    Could you please take an screenshot from "sales"?

    User: "MartinLiebig"
    MartinLiebig
    Altair Employee
    seems like some of your "numbers" are rather something like 1-2?

    I would recommend to use "read all columns as polynominal" option and parse the numbers later.

    Best,
    Martin
    User: "LeMarc"
    LeMarc
    New Altair Community Member
    OP
    Hi, problem is solved. I changed the format of column sales. Thanks!
    User: "Telcontar120"
    Telcontar120
    New Altair Community Member
    You may also have missing values or zero value represented by the hyphen "-" in which case you can use declare missing value or replace operator to solve that problem.

    User: "LeMarc"
    LeMarc
    New Altair Community Member
    OP
    @Telcontar120 Thanks for the hint!
Quick Links