Add Column

Adds a new column to the table with default or Empty values.

This component won't add the column if the column name already exists in the table. If you want to update if it exists, use the "Set Column" component instead.

Add Row

Adds a row to the table.

If row has more fields than the table columns, extra fields will be ignored. If row has less fields than the table columns, missing fields will be set to Empty.

Count Rows

Gets the number of rows in a table.

Create Table

Creates an empty table with given number of rows and columns.

Table cells will be set to Empty.

Delete Column

Deletes a column from the table.

Filter

Filters a table based on given query.

Get Column

Gets a column from the table as a List of cell values.

Get Range

Gets a range of the table between given start and end position range.

Row numbers starts from 1. Negative numbers can be used to get items from the end of the table. For example, -1 means the last row. Range limits are inclusive. Rows at the start and end positions are included in the result.

Get Row

Gets a row from a table by its position.

Get Unique Rows

Removes duplicate rows from a table.

Merge Tables

Merges two tables by appending rows into a new single table.

Rows from first table will be at the top. New table contains all columns from both tables.

Remove Table Range

Removes a range of rows from a table by given start and end positions.

Range limits are inclusive. Rows at the start and end positions are removed too. Position of the rows start from 1. Negative numbers can be used to count from the end. -1 means the last position.

Remove Row By Position

Removes a row from a table by its position.

If the position is outside of the table size, no row will be removed.

Reverse

Reverses the order of rows in a table.

Set Cell

Sets a cell in a table at a given position.

Set Column

Sets the values of a table column. If column does not exist, it will be added to the table.

This component does not change the type of the existing column. If new values have a different type than the existing column, first remove the column with the "Delete Column" component.

Set Row

Sets a row in a table at a given position.

New row will replace the existing row at the given position. If you want to insert without replacing, use the Add Row component. If row has more fields than the table columns, extra fields will be ignored. If row has less fields than the table columns, missing fields will be set to Empty.

Sort Table

Sorts a table by selected columns.

Convert Table to HTML

Converts a table to a formatted table in HTML. You may use this output in an email or a web page.

Convert Table to Plain Text

Converts a table to a formatted table in plain text.

Note that the resulting text may not be perfectly aligned in Monkedo's editor due to spacing limitations. However, if placed into a space with enough width, it will be aligned correctly.

Create Table From Entity

Creates a table from an entity by placing it as the first row.

Convert To List

Converts a table to a list of entities.

Convert Column to Yes/No

Converts a text column into a Yes/No column.

This component is useful especially when a table is created from a source that provides values as text such as CSV files or some spreadsheet apps. Values in the column will be converted to Yes/No.

Convert Column to Date

Converts a text column into a date column.

This component is useful especially when a table is created from a source that provides values as text such as CSV files or some spreadsheet apps. Values in the column will be converted to date. Invalid (non-date or empty) values will be set to Empty.

Convert Column to Number

Converts a text column into a number column.

This component is useful especially when a table is created from a source that provides values as text such as CSV files or some spreadsheet apps. Numeric values in the column will be converted to number. Invalid (non-numeric or empty) values will be set to Empty.