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 |