In this chapter, you will learn how to split columns based on cell values, allowing you to separate combined data into more manageable parts. Next, you will explore the use of conditional statements for data transformation, enabling you to apply specific rules to your dataset. Additionally, you will learn how to use logical operators to formulate logical conditions. Finally, you will discover how to rename one or multiple columns, ensuring your dataset is well-organized and easy to understand.

Conditional statements and logical operators

Assign inflation value

Enhance student data

Split into city and quantity

Rename columns

Assign discount percentage

Delve into Expression- Based Data Transformation, a crucial skill for data manipulation. This lesson covers understanding and utilizing string expressions for various string manipulations. Additionally, you will master mathematical expressions using formulas and operators, enabling them to create custom columns tailored to their needs. The chapter culminates with the ability to build mixed expressions that seamlessly combine mathematical and string expressions, providing a comprehensive toolkit for advanced data transformation.

String and math expressions

Calculate the bill value of Items

Calculate student scores

Convert sales column to numeric

Calculate discount value

Calculate profit

String and Math Expressions

Learn how to append and merge columns from multiple tables, enabling you to consolidate data from various sources. Discover how to add constant value columns and reorder columns to customize your dataset layout. Finally, delve into sorting tables by specifying a list of criteria, ensuring your data is organized and easily accessible for analysis. These skills will enhance your data management proficiency, making complex datasets more manageable and insightful.

Integrasi data

Proses Integrasi Data

Temukan item makanan termahal

Integrasikan dan analisis data siswa

Menambahkan dan menggabungkan kolom

Tambahkan tanggal dan atur ulang kolom

Urutkan tabel

Data Integration

This final chapter focuses on enhancing KNIME workflows by adding detailed descriptions and tags to represent their themes. Further, learn how to abstract workflow segments into reusable KNIME components, bundle functionality, and add visual elements for better usability. 

Lastly, learn to share your workflows and components on the KNIME Community Hub, ensuring they are valuable and accessible to the community.

Share workflows & collaborate

Component characteristics

Share & collaborate student's  workflow

Add workflow details

Create component

Sharing the component

Course wrap up

Exercises and Datasets

DataCamp vs. Local Experience

Transformasi Data di KNIME dirancang untuk membekali Anda dengan teknik-teknik esensial dan menengah dalam memanipulasi serta mentransformasi data menggunakan KNIME. Anda akan mulai dengan mempelajari keterampilan dasar transformasi data, termasuk membagi kolom dan menggunakan pernyataan kondisional. Kursus ini kemudian berlanjut ke tugas yang lebih kompleks, seperti transformasi berbasis ekspresi dan konsolidasi data. Terakhir, Anda akan mempelajari cara meningkatkan alur kerja KNIME dengan membuat komponen yang dapat digunakan kembali dan mengoptimalkan kemampuan penggunaannya. Kursus ini ideal bagi siapa pun yang ingin memperdalam keterampilan pengelolaan data menggunakan KNIME.

Introduction to KNIME

Tingkatkan keterampilan KNIME Anda dengan kursus transformasi data, operasi kolom, dan optimasi alur kerja.

Transformasi Data di KNIME

KNIME Fundamentals

Tambahkan kolom dari kedua tabel ke dalam satu tabel

Gabungkan kolom Discount Price dan Price menjadi kolom Price

Urutkan tabel berdasarkan kolom Category secara menaik

Urutkan tabel berdasarkan kolom Price secara menurun

Amati tabel yang sudah diurutkan untuk menemukan item makanan termahal

ID	Category
1	Sports
2	Food
3	Sports
4	Food

ID	Discount Price	Price
1	20	40
2	?	40
3	30	10
4	?	100

Temukan item makanan termahal

Transformasi Data di KNIME

Latihan interaktif praktis