Transforming Data
Now that we have the basics of KNIME at hand, we can move to the next level. In this chapter, we will learn how to transform data to make the best out of it systematically. The following pages will show how to work with multiple tables, aggregate data points, apply expressions, and iterate through your workflows to automating their execution. All these new skills will make you an autonomous user of KNIME when manipulating real-world data.
This chapter will answer the following questions:
- What is a data model, and how can I visualize it?
- How can I combine several data tables?
- How can I aggregate data points and calculate formulas?
- How can KNIME automate the creation of summary reports?
- What do variables and loops look like in KNIME?
This chapter will end with a full tutorial based on real data and a very realistic business case: it will be an opportunity to put into practice all you've learned so far about KNIME while confronting...