Icon

01 Dealing with String Data

Dealing with String Data

How to use the KNIME Analytics Platform to identify and fix errors in String data.
Reading raw data file without separator
Converting & assigning appropriate column formats
Checking & correcting for invalid values
Extracting new columns from an existing column
Handling white space and case conversion
Changing the case of string columns

  • Remove whitespaces from beginning & end of all string columns

  • OrderDate - string to date conversion

  • Extract Postalcode from OrderNo column

  • Convert all values to uppercase in Gender column

  • Convert empty values to missing in Gender column

Dealing with String Data

How to use the Expression node to fix errors in String data.
Extract eightcolumns
Cell Splitter By Position
Convert to Integer columns
String to Number
Remove whitespacesfrom beginning & end of string
String Manipulation (Multi Column)
Pivot
Invalid Gender
Rule-based Row Filter
Postalcode State List
Table Creator
Convert to Integer columns
String to Number
Bar Chart
Gender count
Value Counter
Expression
Joiner
Gender count
Value Counter
PackageReport.xlsx
Excel Writer
OrderDate conversion
String to Date&Time
ReadingCustomerOrders.txt
File Reader
CustomerOrders.table
Table Writer
Postalcode State List
Table Creator
Summary statistics
Statistics
Joiner
Pivot
Drop unwanted columns
Column Filter
ExtractPostalcode
String Manipulation
Expression
Uppercase Gender
String Manipulation
ReadingCustomerOrders.txt
File Reader
PackageReport.xlsx
Excel Writer
Postalcode count
GroupBy
Bar Chart
Empty string to null Gender
String Manipulation
Extract eightcolumns
Cell Splitter By Position
Drop unwanted columns
Column Filter

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: vijaykrishna.v
Created at: 2021-02-22
On NodePit since: 2024-12-16
Last update: 2026-01-02
Created with KNIME version: v5.8.0

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!