Icon

22_​DB_​Concatenate

DB Concatenate Example
DB Concatenate ExampleThis workflow demonstrates the usage of the DB Concatenate node. The node allows the user combine several database queries with a similarstructure into a single query using a UNION or UNION ALL statement. Node 5Replace with any database connector nodeFilter a subsetof the tableAppendGroup_ID columnwith constant valueNode 14AppendGroup_ID columnwith constant valueCombine input resultsinto a single result.Add more input resultports via the ...AppendGroup_ID columnwith constant valueNode 19Count rowsper Group_IDNode 21DB Table Selector Connect to DB andcreate example data DB Row Filter DB Query DB Row Filter DB Query DB Concatenate DB Query DB Row Filter DB GroupBy DB Reader DB Concatenate ExampleThis workflow demonstrates the usage of the DB Concatenate node. The node allows the user combine several database queries with a similarstructure into a single query using a UNION or UNION ALL statement. Node 5Replace with any database connector nodeFilter a subsetof the tableAppendGroup_ID columnwith constant valueNode 14AppendGroup_ID columnwith constant valueCombine input resultsinto a single result.Add more input resultports via the ...AppendGroup_ID columnwith constant valueNode 19Count rowsper Group_IDNode 21DB Table Selector Connect to DB andcreate example data DB Row Filter DB Query DB Row Filter DB Query DB Concatenate DB Query DB Row Filter DB GroupBy DB Reader

Nodes

Extensions

Links