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

Name

Value

Opt.

Description

Example

Apply to the following columns

System.Object

-

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

-

Settings

Name

Value

Opt.

Description

Example

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:

Identifier

Value

A

--

B

3.00

Settings

Result

Data:

Identifier

Value

A

-1.00

B

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