Datatable

The Datatable data type represents tabular data.

It is primarily used when working with .csv, .tsv, .xlsx and .text files, as well as databases.

Examples

`data` argument of the "Csv file to datatable" adaptor

The "Csv file to datatable" adaptor produces a Datatable from the data argument.

`data` argument of the "Datatable to csv" adaptor

The "Datatable to csv" adaptor accepts a Datatable for the data argument.

Internal Structure

Given the following csv file:

example.csv
col1,col2,col3
1,2,3
A,B,C

An equivalent Datatable would be structured as follows:

example.json
{
columns: [
'col1',
'col2',
'col3'
],
rows: [
{
col1: 1,
col2: 2,
col3: 3
},
{
col1: A,
col2: B,
col3: C
}
]
}