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