L300 - 302 - Smart Import Object

Severino
Severino Active Partner
Board Developer First Comment
in Academy

Hi, I don't understand why when I go to load values via smart import into the cube they appear multiplied by 100, except for the 1 which remains the same.
I think I have set up the smart import correctly but when I go to copy and paste from the excel file it gives me these results:

image.png

For the sake of completeness I copied the excel values back to the smart import, just to show that the data is copied correctly, however as soon as I validate the smart import the cube fills up incorrectly.

What could be the problem?

If someone could help me I would be really grateful.
Thank you!

Answers

  • Severino
    Severino Active Partner
    Board Developer First Comment

    I solved it, excel uses commas board dots to separate the unit and the cents, so by substituting dots for commas from excel and copying to the smart import I get the right result

  • Snehal Barot
    Snehal Barot Employee
    Third Anniversary 10 Comments Name Dropper 5 Likes

    Hi Severino,

    Glad to hear that you managed to figure out the issue!

    Let us know if you encounter any other problems.

    Best wishes,

    Snehal

Categories