Summary

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

Please note:

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

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

none

Want to learn more?

Settings

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

Columns of input table

Parameter

Troubleshooting

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

 

Related topics

Import text or CSV file 3.0

Importing data from SQL sources 3.1