Replacing null values
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:
| ||||||
|---|---|---|---|---|---|---|---|
Settings |
| ||||||
Result | Data:
| ||||||
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.