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

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: Tobias
Created at: 2022-06-03
On NodePit since: 2022-06-15
Last update: 2024-11-17
Created with KNIME version: v4.6.0
Tags: DBQueryConcatenateQuery ConcatenationRelease 4.6

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!