Querying Databases
There has been no title set for this workflow's metadata.
This workflow demonstrates how to query a database to aggregate and filter data and join two database tables.
In this example, the contracts data (~50K rows) are aggregated and filtered to find the products with more than 10K contracts. After that, for these popular products the contracts number is joined to other products data (price, terms). The processing (aggregation, filtering, and joining) happens on the database, and only the small final table (3 rows) is imported into KNIME
Nodes
- DB Table Selector (Labs)2 ×
- DB GroupBy (Labs)1 ×
- DB Joiner (Labs)1 ×
- DB Reader (Labs)1 ×
- DB Row Filter (Labs)1 ×
- Show all 6 nodes
Extensions
Links
- No links available