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.
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.