This workflow demonstrates the usage of the DB Concatenate node. The node allows the user combine several database queries with a similar structure into a single query using a UNION or UNION ALL statement.
The workflow splits-up an input table into three parts using the DB Row Filter. Each part gets a unique Group_ID assigned via the DB Query node. The parts are then combined into a single result which is then aggregated to get the row count per Group_ID.
Workflow
DB Concatenate Example
External resources
Used extensions & nodes
Created with KNIME Analytics Platform version 4.6.0
- Go to item
- Go to item
- Go to item
- Go to item
- Go to item
- Go to item
Legal
By using or downloading the workflow, you agree to our terms and conditions.