Icon

Getting Data from a Database

This workflow lets you find the top 5 Sci-Fi movies rented out in the DVD rentals Database.Please note that you wouldn't be able to open the configuration for some nodes since your computer won't have access to my databaseinstance. If you would like your own instance of the DVD Rentals Database, feel free to contact me and I'll walk you through the set up. Sign in andConnect to DatabaseRentalInventoryFilmCategoryFilm CategoryFilm IDFilm InformationJoin Category NameJoin in CategoryFilter out othermovie categoriesCount times amovie was rentedSort by countof rentalsTop 5 Sci-fi movies rentedRead resultsCode to performthe Query PostgreSQLConnector DB Table Selector DB Table Selector DB Table Selector DB Table Selector DB Table Selector DB Joiner DB Joiner DB Joiner DB Joiner DB Row Filter DB GroupBy DB Sorter DB Row Sampling DB Reader DB Query Reader This workflow lets you find the top 5 Sci-Fi movies rented out in the DVD rentals Database.Please note that you wouldn't be able to open the configuration for some nodes since your computer won't have access to my databaseinstance. If you would like your own instance of the DVD Rentals Database, feel free to contact me and I'll walk you through the set up. Sign in andConnect to DatabaseRentalInventoryFilmCategoryFilm CategoryFilm IDFilm InformationJoin Category NameJoin in CategoryFilter out othermovie categoriesCount times amovie was rentedSort by countof rentalsTop 5 Sci-fi movies rentedRead resultsCode to performthe QueryPostgreSQLConnector DB Table Selector DB Table Selector DB Table Selector DB Table Selector DB Table Selector DB Joiner DB Joiner DB Joiner DB Joiner DB Row Filter DB GroupBy DB Sorter DB Row Sampling DB Reader DB Query 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: sntra
Created at: 2021-06-06
On NodePit since: 2021-12-19
Last update: 2024-04-27
Created with KNIME version: v4.4.1

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

Try NodePit Runner!