convert-list-to-datatable

Description

convert-list-to-datatable adaptor is used to create a one-column datatable from values in a list.

Inputs

list Type: list Required: Yes The list to be converted to a datatable.

column name Type: text Required: No The name of the new datatable column. If unspecified, defaults to value.

Outputs

data Type: datatable A single-column datatable containing the list values.

Examples

Example 1: Default behaviour.

Inputs:

data:

• Spring

• Summer

• Autumn

• Winter

column name: Season

Outputs:

data:

Season
Spring
Summer
Autumn
Winter

-> Converted list into a datatable with Season column.

Use Cases

• Data tables provide a structured and tabular representation of data from a list

• Data tables are a common format for storing and analyzing data in tools like Excel, Python, R and Microreact

• Convert a text list to a datatable to add additional columns and data elements using the add-column adaptor