Public

Challenge 19 - Pokémon Local Database Level: Medium Description: Recently you have been feeling a bit nostalgic about Pokémon and our related challenge from Season 3, and decided to use the PokeAPI to create your own local database of fantastical creatures. Through the API, you retrieved the dataset of each Pokémon and their types, and then created pokemonAPI_Local.sqlite: a local database. Now you want to create a workflow that fetches data from this database and outputs a list of Pokémon types in descending order of frequency. For a little extra challenge, how about automatically retrieving the latest data from the PokeAPI and updating each data table accordingly? Hint: A lot of the processing should happen within the database for efficiency. Please use the KNIME Database extension in your solution. Author: Yasue Katsutaka Dataset: Pokémon Database on KNIME Community Hub

Last edited  Oct 3, 2025 7:46 AM