Error while computing large number

B

I've got an error while computing a large number (ie somtehing like 10^18). The formula "MJ*1000000" retruns negative value in column "J" for some rows and the correct value for others… Does someone as an explanation and a solution ? Thanks very much in advance

Yasmine_T

Hi!

I hope that you are doing well.

I was wondering which version of DSS you are using here? I was unable to reproduce the behavior on my end. Is there any other steps being taken/applied in your prepare recipe?

Also are you seeing the same behavior in the formula preview within your recipe?:)

Best,

Yasmine

B

https://community.dataiku.com/discussion/comment/45953#Comment_45953

Hi Yasmine, thanks for your answer. The step before the behaviour :

1. upload of an excel spreadsheet
2. The MJ column is a string
3. format the column MJ from english to raw (in a prepare receipe)
4. I change the format of the column to double
5. formula J = MJ*1000000 in the same prepare receipe
6. and then the behaviour happens (even beofre running the receipe)
   
   I'm usine Dataiku DSS

Version: 13.1.4

Thanks again for your consideration

Yasmine_T

Hi,

I hope that you are doing well:)

Would you mind sending me a screenshot of your prepare recipe steps (opened if possible) so i can try to match your steps as best as i can?

We don't have anything similar reported here. I can suggest upgrading to 13.5.2 in the meantime (this is the version i've tested your use case on based on the formula and dataset value).

I'd love to see all of the steps present within your prepare recipe as well as your running engine just in case!

Best,

Yasmine

B

Hi,

Here you have the two steps that lead to the error. I filtered the sample on a value of "MJ" that I know doesn't work. I tried to change le "J" format to duble in the last screenshot but the same situation occurs.

Thanks

Benoit

B

Up ^. Anyone ? Thanks in advance (@Yasmine_T ?)

Turribeach

Where is your dataset stored on? Can you use SQL Engine instead?