L1 Wrong Import: Decimal Data imported as Integer

SalouaA
SalouaA
in Integrations and extensibility

I'm having this constant issue

When importing from an excel worksheet . if i try to import decimal numbers into a module . The number becomes an integer.

Example : 20003.44851 becomes 2,000,344,851.0

PS : -the target format is Number

-No error is displayed

What i got

1.png

What i was aiming for

image.png

Can you please help me figure out the source problem

Than you

Best Answer

  • Misbah
    Misbah
    Answer ✓

    @SalouaA

    When you created an import, you must have overlooked one parameter on the first window/pop up i.e., thousand separator. Change it and then re run the import.

    If you are a beginner I would say create a new Import and pay attention to this field.

    If you are at advanced level, Click on Manage Import Data Source and change the Source file and then change the parameter of thousand separator.

    Hope that helps

    Misbah

    Miz Logix

Categories