Summary

Cells with no content are filled with a certain value. Operation is only allowed in columns containing numbers.

Configuration

Input settings of existing table

NameValueOpt.DescriptionExample
Apply to the following columns

System.Object

-Enter the desired column name, e.g. A, C-H, K-

Settings

NameValueOpt.DescriptionExample
New value

System.String

-Enter the value which replaces null values.-

Remarks

  • NULL-values mean missing values, not cells containing the value zero (0).
  • NULL-values occur rarely in TIS, because they are usually dealt with earlier on (e.g., import). However, in certain operations which calculate or the Length operator, NULL-values can be a problem. 

Want to learn more?

Cells with no content are filled with a certain value. Operation is only allowed in columns containing numbers.

Examples

Example: Replace NULL-values (missing values) with -1

Situation

Data:

IdentifierValue
A--
B3.00
Settings
Result

Data:

IdentifierValue
A-1.00
B3.00
Project File-

Example: Missing birthdays

Situation

Data:

Settings

Result

Data:

Project File-

Troubleshooting

Sometimes it is better to delete a row containing missing values than to replace the missing value with a different value.


Related topics