These Table Operations blocks perform various operations for creating and managing tables.
Block | Icon | Description |
---|---|---|
CSV Parser | Converts a CSV string into a table | |
CSV Writer | Takes an input table and returns the table as a CSV string | |
JSON Parser | Converts a JSON string into a table | |
Column Mapping | Returns a new table that can include specified columns from the input table and can include new columns that contain calculated values | |
Sort | Returns a new table that reorders the input table’s rows | |
Filter | Returns a new table that contains only the rows from the input table that meet a condition | |
Group By | Returns a new table that contains one row for each group of rows in the input table | |
Join | Returns a new table that joins the rows of two input tables | |
Page | Returns a specified portion of the input table based on paging parameters | |
Rollup | Returns a new table that contains one row for each date and time interval in the input table | |
Aggregation | Returns a value that reflects the table records in the specified column | |
Select Rows | Returns a table that contains only the specified rows from the input table | |
Select Columns | Returns a table that contains only the defined column names from the input table | |
Get Columns | Returns a table that contains the names and data types of the input table's columns | |
Table Row Cells | Returns values from the specified cells in a certain row | |
Add Row | Adds a row to the input table | |
Remove Rows | no icon | Deletes rows from the input table |
Edit Rows | Replaces values in the input table | |
Transpose | Transposes a table, so that the columns in the input table are rows in the output table | |
Realtime Recorder | Monitors changes to specified values and creates a table to record current and historical values | |
Series Realtime Recorder | no icon | Monitors the single current value of each specified metric and creates a table of those current values without storing historical values |