Icon

Tutorial-H_​Data-integration1

<p>This tutorial is part of a series of tutorials on the topic of data preparation (Tutorial_G – Tutorial_O). These tutorials are included in the book, <em>Handbook of Statistical Analysis, AI, and ML Applications (Elsevier Publishers, 2025). </em>These tutorials will guide you to build KNIME workflows to perform common data preparation tasks. You can adapt these workflows easily to load and process your own datasets.</p><p>---</p><p>The publisher has graciously permitted these tutorials to be included on the KNIME Community Hub and has provided the 30% discount code <em>MATH30</em> to purchase the book from https://shop.elsevier.com/books/handbook-of-statistical-analysis/nisbet/978-0-443-15845-2.</p>

Tutorial H - Data Integration


An important part of the initial data preparation efforts consists of tasks of data acquisition and data integration. Data acquisition can often be stressful, because the stakeholders of the dataset may require a rather extensive set of security steps before data can be accessed, sometimes from different sources. Assuming that four datasets are available for use, this tutorial walks through a task to integrate data found in multiple data sources. Here, it is assumed that the datasets are in a flat-file format. The data sources are combined into a suitable structure where all variables are fields in a record. The result of this tutorial will be one single file containing all variables and their relevant data to be input into a mining tool.

Review Tutorial_H for more detailed instructions.

Load files from the Data/ directory:

  • Donors2.csv

  • Demographics.csv

  • Donors_Hist.csv (disable row limit in advanced tab to read file)

  • Promo_Hist.csv

Successively join the tables from the initial files into one integrated table

Write integrated table to a CSV file

Nodes

  • No nodes found

Extensions

  • No modules found

Links