Format decimal

edoardop
edoardop Registered Posts: 1 ✭✭✭

Hello,

i formatted an double to reduce the decimals using the round function. The formula works fine and it creates a table with the new values with only 2 decimals. The issue is that when I crate a new recipe in the newly created table, the format is not kept meaning the values will go back to many decimals.

any though why is this happening?

Answers

  • VitaliyD
    VitaliyD Dataiker, Dataiku DSS Core Designer, Dataiku DSS Adv Designer Posts: 102 Dataiker

    Hi,

    Suppose you are talking about prepare recipe. In that case, it will always try to autodetect meanings based on the values, so if you have many decimals again, then the values from the database have the decimals. To say more, we will need additional information on what database type and what recipe you are using. If you can provide screenshots of your flow and screenshots of the input dataset, recipe view and output dataset displaying the column in question, for sure, it will help to provide more appropriate guidance.

    Best.

Setup Info
    Tags
      Help me…