When adding new columns to existing model it’s possible to add default values with the data conversion.
I would like to produce a specific value for each row that is the result of a query.
With this i can calculate and populate the new column with a value.
All the votes have been transferred into this idea.
Updated idea status Working on it! → Next release
In the 2021.1 version of the Thinkwise Platform, we introduced expressions in default values. In the 2021.3 version, this will also become available in the data conversion screen.
This makes it possible to use an expression to fill new or changed columns during the upgrade. A new Default value type field has been added to be able to toggle between a constant value and an expression.
As some of our most experienced users may know, we already provided an option to specify a default value preceded by an =. In the 2021.3 version, this will be replaced by the default value expression, which is a more formal way of achieving the same.
The upgrade to the 2021.3 will provide a conversion so that default values preceded by an = will be transferred (without the =) to the default expression field.