Table Operations
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 |
| Table to JSON String | no icon | Returns the input table as a JSON string (an array with one object per row) |
| 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 |
| Multi-Join | | Returns a new table that joins the rows of two or more input tables on a single column |
| 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 |
| Advanced Rollup | no icon | Like Rollup, but each value column has its own rollup method and output column name |
| 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 |
| Map to Table | no icon | Converts a table row or a map into a table with one row |