replace-blank-values

Description

replace-blank-values adaptor replaces blank values in a datatable column.

This adaptor only replaces blank values, to replace existing values in a datatable column, use the replace-values-in-columns adaptor. This adaptor may be used for a single column, or replacing blank values across multiple columns.

Inputs

data Type: datatable Required: Yes The datatable containing blank values.

columns Type: list Required: Yes The names of the columns in data containing blank values.

new value Type: text Required: Yes A value to replace blank values.

Outputs

data Type: datatable A datatable with the blank values replaced.

Examples

Example 1: Default behaviour.

Inputs:

data:

id	code	name
1	GB	United Kingdom
2	TR	Turkey
3	US
4	IND	India
5	IND	India
6	us

columns:

1. name

new value: United States

Outputs:

data:

id	country code	country name
1	GB	United Kingdom
2	TR	Turkey
3	US	United States
4	IND	India
5	IND	India
6	us	United States

-> Replaced the blank values with United States in the datatable.

Example 2: Replace blank values in multiple columns.

Inputs:

data:

id	code	name
1	GB	United Kingdom
2		Turkey
3	US
4	IND	India
5		India
6	us

columns:

1. code, name

new value: Missing

Outputs:

data:

id	country code	country name
1	GB	United Kingdom
2	Missing	Turkey
3	US	Missing
4	IND	India
5	Missing	India
6	us	Missing

-> Replaced the blank values in the code and name columns with Missing in the datatable.

Use Cases

• Standardise values for missing information.

• Filling in a column after joining datatables.