Challenge 19: Pokemon 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
Remember to upload your solution with tag JKISeason4-19 to your public space on KNIME Community Hub. To increase the visibility of your solution, also post it to this challenge thread on KNIME Forum.