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
Name | Value | Opt. | Description | Example |
|---|---|---|---|---|
Apply to the following columns | System.Object | - | Enter the desired column name, e.g. A, C-H, K | - |
Settings
Name | Value | Opt. | Description | Example |
|---|---|---|---|---|
New value | System.String | - | 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.