https://wiki.dglogik.com/ 2026-04-25T13:37:21+0000 https://wiki.dglogik.com/ https://wiki.dglogik.com/lib/tpl/bootstrap3/images/favicon.ico text/html 2021-09-20T15:03:06+0000 Anonymous (anonymous@undisclosed.example.com) https://wiki.dglogik.com/dglux5_wiki:dataflow:dataflow_blocks_reference:table_operations:add_row?rev=1632150186&do=diff Add Row Block Group: Table OperationsIcon: [Add Row block icon] The Add Row block adds a row to the input table. When this block’s trigger is invoked, a new row is created in the input table. The new row contains the values specified by this block’s properties. The input table must be a table that can be written to, such as the value stored by a text/html 2021-09-20T15:03:06+0000 Anonymous (anonymous@undisclosed.example.com) https://wiki.dglogik.com/dglux5_wiki:dataflow:dataflow_blocks_reference:table_operations:aggregation?rev=1632150186&do=diff Aggregation Block Group: Table OperationsIcon:[Aggregation block icon] The Aggregation block returns a value that reflects the table records in the specified column. For information on using dataflow blocks, see Dataflow. For answers to some common questions about working with tables, see Tables. ---------- text/html 2021-09-20T15:03:06+0000 Anonymous (anonymous@undisclosed.example.com) https://wiki.dglogik.com/dglux5_wiki:dataflow:dataflow_blocks_reference:table_operations:column_mapping?rev=1632150186&do=diff Column Mapping Block Group: Table OperationsIcon:[Column Mapping block icon] The Column Mapping block returns a new table that can include specified columns from the input table and can include new columns that contain calculated values. For information on using dataflow blocks, see Dataflow. For answers to some common questions about working with tables, see text/html 2021-09-20T15:03:06+0000 Anonymous (anonymous@undisclosed.example.com) https://wiki.dglogik.com/dglux5_wiki:dataflow:dataflow_blocks_reference:table_operations:csv_parser?rev=1632150186&do=diff CSV Parser Block Group: Table OperationsIcon:[CSV Parser block icon] The CSV Parser block converts a CSV string into a table. This is a commonly used block, because many data-driven features in DGLux5, such as charts and repeaters, require tabular data. The CSV parser block is often used to parse a string that has been retrieved using a text/html 2021-09-20T15:03:07+0000 Anonymous (anonymous@undisclosed.example.com) https://wiki.dglogik.com/dglux5_wiki:dataflow:dataflow_blocks_reference:table_operations:csv_writer?rev=1632150187&do=diff CSV Writer Block Group: Table OperationsIcon:[CSV Writer block icon] The CSV Writer block takes an input table and returns the table as a CSV string. For information on using dataflow blocks, see Dataflow. For answers to some common questions about working with tables, see Tables. ---------- Input/Output Properties text/html 2021-09-20T15:03:07+0000 Anonymous (anonymous@undisclosed.example.com) https://wiki.dglogik.com/dglux5_wiki:dataflow:dataflow_blocks_reference:table_operations:edit_rows?rev=1632150187&do=diff Edit Rows Block Group: Table OperationsIcon: [Edit Rows block icon] The Edit Rows block replaces values in the input table. When the block’s trigger is invoked, rows that meet the specified criteria receive the specified value replacements. The input table must be a table that can be written to, such as the value stored by a text/html 2021-09-20T15:03:07+0000 Anonymous (anonymous@undisclosed.example.com) https://wiki.dglogik.com/dglux5_wiki:dataflow:dataflow_blocks_reference:table_operations:filter?rev=1632150187&do=diff Filter Block Group: Table OperationsIcon:[Filter block icon] The Filter block returns a new table that contains only the rows from the input table that meet a condition. For information on using dataflow blocks, see Dataflow. For answers to some common questions about working with tables, see text/html 2021-09-20T15:03:07+0000 Anonymous (anonymous@undisclosed.example.com) https://wiki.dglogik.com/dglux5_wiki:dataflow:dataflow_blocks_reference:table_operations:get_columns?rev=1632150187&do=diff Get Columns Block Group: Table Operations Icon: [Get Columns block icon] The Get Columns block returns a table that contains the names and data types of the input table's columns. Note text/html 2021-09-20T15:03:07+0000 Anonymous (anonymous@undisclosed.example.com) https://wiki.dglogik.com/dglux5_wiki:dataflow:dataflow_blocks_reference:table_operations:group_by?rev=1632150187&do=diff Group By Block Group: Table OperationsIcon:[Group By block icon] The Group By block returns a new table that contains one row for each group of rows in the input table. A group is composed of rows that hold an identical value in the specified column. For information on using dataflow blocks, see text/html 2021-09-20T15:03:07+0000 Anonymous (anonymous@undisclosed.example.com) https://wiki.dglogik.com/dglux5_wiki:dataflow:dataflow_blocks_reference:table_operations:home?rev=1632150187&do=diff Table Operations These Table Operations blocks perform various operations for creating and managing tables. Block Icon text/html 2021-09-20T15:03:07+0000 Anonymous (anonymous@undisclosed.example.com) https://wiki.dglogik.com/dglux5_wiki:dataflow:dataflow_blocks_reference:table_operations:join?rev=1632150187&do=diff Join Block Group: Table OperationsIcon:[Join block icon] The Join block returns a new table that joins the rows of two input tables. Note Make sure to rename columns using the renameColumns property, if you don’t want the columns to be combined. For information on using dataflow blocks, see text/html 2021-09-20T15:03:07+0000 Anonymous (anonymous@undisclosed.example.com) https://wiki.dglogik.com/dglux5_wiki:dataflow:dataflow_blocks_reference:table_operations:json_parser?rev=1632150187&do=diff JSON Parser Block Group: Table OperationsIcon:[JSON Parser block icon] The JSON Parser block converts a JSON string into a table. The output table can contain other tables within itself. For more information about nested tables, see How to View the Contents of Nested Tables. This is a commonly used block, because many data-driven features in DGLux5, such as charts and repeaters, require tabular data. text/html 2021-09-20T15:03:07+0000 Anonymous (anonymous@undisclosed.example.com) https://wiki.dglogik.com/dglux5_wiki:dataflow:dataflow_blocks_reference:table_operations:multijoin?rev=1632150187&do=diff Multi-Join Block Group: Table OperationsIcon:[Join block icon] The Multi-Join block returns a new table that joins the rows of two or more input tables on a specified single column. The resulting table includes all rows from the first table, plus rows from the subsequent tables that match values in the specified column. Unlike the Join block, you cannot specify the type of join to be performed - this block performs a left outer join that treats table 0 as the left-hand table. text/html 2021-09-20T15:03:07+0000 Anonymous (anonymous@undisclosed.example.com) https://wiki.dglogik.com/dglux5_wiki:dataflow:dataflow_blocks_reference:table_operations:page?rev=1632150187&do=diff Page Block Group: Table OperationsIcon:[Page block icon] The Page block returns a specified portion of the input table based on paging parameters. This block is useful when designing an interface for paging through data. Regardless of whether the Page block is used, all of the input table data is loaded in browser memory. Therefore, paging does not improve performance. text/html 2021-09-20T15:03:07+0000 Anonymous (anonymous@undisclosed.example.com) https://wiki.dglogik.com/dglux5_wiki:dataflow:dataflow_blocks_reference:table_operations:realtime_recorder?rev=1632150187&do=diff Realtime Recorder Block Group: Table OperationsIcon:[Realtime Recorder block icon] The Realtime Recorder block monitors changes to specified values and creates a table to record current and historical values. Every time one of the monitored values changes, a row is added to the table with a timestamp and all of the values. text/html 2021-09-20T15:03:07+0000 Anonymous (anonymous@undisclosed.example.com) https://wiki.dglogik.com/dglux5_wiki:dataflow:dataflow_blocks_reference:table_operations:remove_rows?rev=1632150187&do=diff Remove Rows Block Group: Table OperationsIcon: no icon The Remove Rows block deletes rows from the input table. When the block’s trigger is invoked, rows that meet the specified criteria are deleted from the input table. The input table must be a table that can be written to, such as the value stored by a text/html 2021-09-20T15:03:07+0000 Anonymous (anonymous@undisclosed.example.com) https://wiki.dglogik.com/dglux5_wiki:dataflow:dataflow_blocks_reference:table_operations:rollup?rev=1632150187&do=diff Rollup Block Group: Table OperationsIcon:[Rollup block icon] The Rollup block returns a new table that contains one row for each date and time interval in the input table. The output table contains one column for the date and time interval and one column for the value. For information on using dataflow blocks, see text/html 2021-09-20T15:03:07+0000 Anonymous (anonymous@undisclosed.example.com) https://wiki.dglogik.com/dglux5_wiki:dataflow:dataflow_blocks_reference:table_operations:select_columns?rev=1632150187&do=diff Select Columns Block Group:Table OperationsIcon:[Select Columns block icon] The Select Columns block returns a table that contains only the defined column names from the input table. For information on using dataflow blocks, see Dataflow. For answers to some common questions about working with tables, see text/html 2021-09-20T15:03:07+0000 Anonymous (anonymous@undisclosed.example.com) https://wiki.dglogik.com/dglux5_wiki:dataflow:dataflow_blocks_reference:table_operations:select_rows?rev=1632150187&do=diff Select Rows Block Group: Table Operations Icon: [Select Rows block icon] The Select Rows block returns a table that contains only the specified rows from the input table. For information on using dataflow blocks, see text/html 2021-09-20T15:03:07+0000 Anonymous (anonymous@undisclosed.example.com) https://wiki.dglogik.com/dglux5_wiki:dataflow:dataflow_blocks_reference:table_operations:series_realtime_recorder?rev=1632150187&do=diff Series Realtime Recorder Block Group: Table OperationsIcon:[Realtime Recorder block icon] The Series Realtime Recorder block monitors the single current value of each specified metric and creates a table of those current values without storing historical values. For information on using dataflow blocks, see text/html 2021-09-20T15:03:07+0000 Anonymous (anonymous@undisclosed.example.com) https://wiki.dglogik.com/dglux5_wiki:dataflow:dataflow_blocks_reference:table_operations:sort?rev=1632150187&do=diff Sort Block Group: Table OperationsIcon:[Sort block icon] The Sort block returns a new table that reorders the input table’s rows. For information on using dataflow blocks, see Dataflow. For answers to some common questions about working with tables, see Tables. ---------- Input/Output Properties text/html 2021-09-20T15:03:07+0000 Anonymous (anonymous@undisclosed.example.com) https://wiki.dglogik.com/dglux5_wiki:dataflow:dataflow_blocks_reference:table_operations:table_row_cells?rev=1632150187&do=diff Table Row Cells Block Group: Table OperationsIcon:[Table Row Cells block icon] The Table Row Cells block returns values from the specified cells in a certain row. In addition, the Table Row Cells block can also write to the input table, if the input table is a Table block. Caution In some cases, the Table Row Cells block writes to its input table. text/html 2021-09-20T15:03:07+0000 Anonymous (anonymous@undisclosed.example.com) https://wiki.dglogik.com/dglux5_wiki:dataflow:dataflow_blocks_reference:table_operations:transpose?rev=1632150187&do=diff Transpose Block Group: Table OperationsIcon:[Transpose block icon] The Transpose block returns a new table that transposes the input table, so that the columns in the input table are rows in the output table. Optionally, you can set columns to omit from the output. You can also set an input column to be the header row of the output table.