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
System.ObjectName Value Opt. Description Example Apply to the following columns - Enter the desired column name, e.g. A, C-H, K -
Settings
System.StringName Value Opt. Description Example New value - Enter the value which replaces null values. -
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.
Related topics
- Operators (alphabetical overview)
- Cut values
- Delete rows 2.0
- Import text or CSV file with manual column assignment 3.0
- Importing data from SQL sources 5.0