Skip to main content
Completed

Data conversion support lookup query or join

Related products:Software Factory

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.

Did this topic help you find an answer to your question?

6 replies

Jasper
Superhero
  • 678 replies
  • October 28, 2020
Updated idea status NewOpen

Jeroen van den Belt
Administrator
Forum|alt.badge.img+9
Updated idea status OpenOn the backlog

Jeroen van den Belt
Administrator
Forum|alt.badge.img+9
The following idea has been merged into this idea:

All the votes have been transferred into this idea.

Jeroen van den Belt
Administrator
Forum|alt.badge.img+9
Updated idea status On the backlogWorking on it!

Jeroen van den Belt
Administrator
Forum|alt.badge.img+9

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.

An example of a default expression for column in the data conversion

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.


Jeroen van den Belt
Administrator
Forum|alt.badge.img+9
Updated idea statusNext releaseCompleted

Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings