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.