Course Focus
Learn all about flow variables, different workflow controls such as loops, switches, and how to catch errors. And lastly learn how to visualize your data, export your results, format your Excel tables, and look beyond data wrangling towards data science, training your first classification model.
This is an instructor-led course consisting of four, one hour online sessions run by one of our KNIME data scientists. Each session has an exercise for you to complete at home and together, we will go through the solution at the start of the following session. The course concludes with a 15-minute wrap-up session.
Course Content
Session 1: Data visualization and data export
Session 2: Flow variables
Session 3: Workflow control
Session 4: Styling Excel tables and introduction to machine learning
Hi Heather, tried to download the component “Interactive Data Cleaning” which was mentioned in the course, from Interactive Data Cleaning – KNIME Hub.
First I logged in, then I dragged the node into my computer
All I got is a
Hi gjoe4!
You need to drag and drop the component into the Workflow Editor - so if you have a workflow open you drag it into the editor showing the workflow.
Here’s a little gif.
Hi, I have a question regarding KNIME’s “Publish selection events” as part of graphs, visuals and dashboards. Could you clarify what publishing means? Does that mean that the graphs/data I create in KNIME analytics platform could be seen by others, saved or found in a public space? Thank you for clarifying.
It means publishing the selection event to other visualization nodes in the same component.
E.g. you have two scatter plots in one component with publish selection events activated. If you open the interactive view of the component and you select some values in one of the scatter plot then this selection is also propagated to the other scatter plot and the corresponding values are represented with bigger dots.
@Kathrin Thank you for the detail. Do you have an answer to the second part of the question? Does publishing mean that graphs/data I create in KNIME analytics platform could be seen by others, saved or found in a public space? Or is “publishing” a term only, that describes creating a graph/dashboard? I just want to be sure that data/graphs is safe with the creator and does not show publicly.
@RobertB no, publishing doesn’t mean that your graph is available somewhere else. I will run the session tomorrow and happy to show a little example to make it clear
I am facing some difficulty with reading multiple excel files containing sheets in them. The read excel sheet names seem to be working correctly along with reading the sheets within a file. However the data of the second sheet is not getting appended in the final data file and was wondering how to overcome this issue. I have attached a sample file. (E.g. File 2010 has an extra sheet1 and file 2022 has an extra sheet too. But values from these files are not getting appended into the final file) Multiplefilereading.knar (49.4 KB)
Thank you mlauber71. What I figured out is that I need to preselect “Sheet with a name” checkbox in the Excel reader node and then it works. Will try to go through the solution you posted. Thank you once again.
