remove-columns

Description

The remove-columns adaptor is used to exclude specified columns from a datatable.

Inputs

data Type: datatable Required: Yes The datatable containing the columns to be removed.

columns Type: list Required: Yes The list of columns to be removed.

Outputs

data Type: datatable A datatable with the specified columns removed.

Examples

Example 1: Default behaviour.

Inputs:

data:

Year	Month	Sales (USD)	Sales (GBP)	Sales (EUR)
2020	Jan	1458	1156	1345
2020	Feb	9874	7835	9110
2020	Mar	4562	3601	4173
2020	Apr	3654	2885	3342

columns:

1. Sales (USD)

2. Sales (GBP)

3. Sales (EUR)

Outputs:

data:

Year	Month
2020	Jan
2020	Feb
2020	Mar
2020	Apr

-> Removed columns Sales (USD), Sales (GBP), Sales (EUR) from the datatable.

Use Cases

• Clean up data to keep essential columns.

• Remove columns including sensitive information for data sharing.

• Remove unwanted columns after using the split-column adapter.