02 Data Cleaning - Exercise – KNIME Community Hub

This workflow shows a hands-on exercise in the L1-DW KNIME Analytics Platform for Data Wranglers: Basics course

This is a companion discussion topic for the original entry at https://hub.knime.com/-/spaces/-/latest/~-jxME7e956MSYmr_/

Hi! Task 2 “02 Data Cleaning” from the L1-DW course asks us to “Exclude the Rank Column” from the Demographics.sqlite database, but it’s fairly obscure: for a while, I thought the column simply didn’t exist because the provided workflow is preconfigured to read the LifeExpectancy table (which does not have a Rank column) in the DB Table Selector node, when it should be the JoinedTable table instead (which does). It’s only as I typed this message that I finally realized this. It would be better if the relevant node was either pre-configured to select the JoinedTable table, or simply had to be created manually by the user - which would force them to explore the database and find the relevant table. Thanks!

1 Like

Hi @btoulas -

Welcome to the forum, and thanks for the feedback!