Components

Enso components operate on specific types of data. Beginning, and even some intermediate users may never need anything beyond components that operate on Tables. Full documentation for all components exists here.

Below you will find component documentation for Enso Table components, as well as those specific to Microsoft Excel Workbooks.

You can add a component to the Graph Editor by clicking the + at the lower right of the Graph Editor, or by dragging a data file to begin building a workflow. To connect tools, click the + beneath an existing component or drag down from the output anchor at the bottom of the component.

Component Categories

Input

Enso supports a variety of different ways to bring in data, but Data.read is the most common and can support files, database tables, web APIs and more. See Connecting to Data for additional ways to get data into Enso.

Component	Description
Data.read	Reads a file into Enso.

Excel Workbook

The components in this group work when connected to a Data.read that has opened an Excel Workbook.

Component	Description
read	Reads a worksheet or range from an Excel Workbook opened with Data.read into Enso.
read_many	Reads one or more worksheets from an Excel Workbook, and unions them into a single table.
sheet_names	Returns a vector (list) of sheet names in the workbook.
sheet_count	Returns the number of sheets in the workbook.
named_ranges	Returns a vector (list) of named ranges in the workbook.
named_ranges_count	Returns the number of named ranges in the workbook.
xls_format	Is the workbook in the legacy XLS format? True/False

Output

Component	Description
write	Writes a table to a file.
select_into_database_table	Creates a new database table from this in-memory table.
update_rows	Updates the target table with the contents of this table.
delete_rows	Removes rows from a database table.

Calculations

Calculations components include functions for aggregation, joining, merging, and reshaping data, allowing users to efficiently process and prepare their information for further analysis or visualization

Component	Description
aggregate	Aggregates the rows in a table using group_by columns.
crosstab	Summarize using a field as the column header.
join	Joins two tables according to the specified join conditions.
cross_join	Pair every row of the left table with every row of the right.
merge	Merges this table with a lookup table.
zip	Joins two tables by row position.
union	Appends records from other table(s) to this table.
expand_to_rows	Expand aggregate values in a column to separate rows.
expand_column	Expand a column of objects to a new set of columns.

Conversions

Conversion Components are designed to facilitate the transformation of data from one format or structure to another, enabling seamless integration and manipulation within various workflows. These components allow users to convert data types, or transforming date formats to ensure consistency across datasets. Conversion components are crucial for preparing data for analysis, ensuring that all data inputs are compatible with the operations and analyses to be performed. By providing a range of conversion options, Enso empowers users to tailor their data processing to meet specific analytical needs, improving the accuracy and efficiency of data-driven decision-making processes.

Component	Description
parse	Parses text columns to a specific data type, including numeric, date, date-time and boolean.
cast	Change the data type of columns to a different data types.
auto_cast	Aggregates the rows in a table using group_by columns.
auto_value_types	Automatically detect the appropriate data type and size for specified columns and changes them. This is most useful for Mixed types to narrow down the type if all values could fit into one type.
format	Formats columns within a Table to a specific text or date time format.
split_to_columns	Returns a new table with the chosen column split by delimiter, up to the maximum specified in column_count.
split_to_rows	Returns a new table with the chosen column split by delimiter into rows.
parse_to_columns	Converts a Text column into new columns using a regular expression pattern.
tokenize_to_columns	Returns a new table with the chosen column split by pattern, up to the maximum specified in column_count.
tokenize_to_rows	Returns a new table with the chosen column split by pattern into rows.
to_csv	Creates a text representation of the table using the CSV format.
to_xml	Returns an XML_Document representation of the table.

Selections

Selection components provide powerful tools for filtering, sorting, and extracting specific data points or subsets from larger datasets. These components enable users to precisely define criteria for data selection, allowing for targeted analysis and the creation of focused datasets tailored to specific analytical needs or reporting requirements.

Component	Description
sort	Reorders the table by sorting them based on the specified columns and text_ordering method
reverse	Returns a table containing the rows of input table with their order reversed.
distinct	Returns the distinct (unique) set of rows within the specified columns from the input table.
duplicates	Returns the set of rows which are duplicated within the specified columns from the input table.
filter	Filter is used to select data from a table using a condition.
filter_blank_rows	Remove rows which are all blank or containing blank values.
filter_blank_rows	Remove rows which are all blank or containing blank values.
at	Gets a single specified column, as a Column object, from the input table
first_column	Gets the first column, as a Column object, from the input table
last_column	Gets the last column, as a Column object, from the input table
remove_blank_columns	Remove columns which are either all blank or contain blank values. If no rows are present, all columns are considered blank.
remove_columns	Returns a new table with a chosen subset of columns, as specified by the columns, from the input table. Any unmatched input columns will be dropped from the output.
sort_columns	Reorders the columns by sorting them based on the specified order and text_ordering method.
drop	Creates a new Table from the input with the specified range of rows removed.
first_row	Returns the first row of the table.
get_row	Returns a specified row of the table.
last_row	Returns the last row of the table.
take	Creates a new Table with the specified range of rows from the input Table.

Values

Component	Description
set	Creates or updates a column with a formula or a constant value.
add_row_number	Adds a new column to the table enumerating the rows. Optionally group by a column and set a sort for the ranking.
running	Adds a new column to the table with a running calculation..
fill_nothing	Returns a new table where missing values in the specified columns have been replaced with the provided default(s).
fill_empty	Returns a new column where empty Text values have been replaced with the provided default(s).

Text

Component	Description
replace	Replaces values in the columns using lookup_table to specify a mapping from old to new values.
text_replace	Replaces the first, or all occurrences of term with new_text in each row of the specified column.
text_cleanse	Applies the specified cleansings to the text in each row of the specified columns.

Metadata

Component	Description
column_count	Returns the number of columns in the table.
column_names	Returns the vector (list) of column names contained in this table.
column_info	Returns a Table describing this table's contents. The table lists all columns, counts of non-null items and value types of each column.
row_count	Returns a the number of rows in the table.
rename_columns	Returns a new table with the chosen columns renamed.
use_first_row_as_names	Returns a new table with the columns renamed based on entries in the first row.