Hub
Pricing About
WorkflowWorkflow

Dataset cleaning and formatting

Release 5.2Data cleaningString manipulation
knime profile image
Versionv1.0Latest, created on 
Dec 6, 2023 9:29 AM
Drag & drop
Like
Download workflow
Workflow preview
This workflow demonstrates how to use the "String Format Manager" node in conjunction with the "Number Format Manager" and "String Cleaner" nodes. The format manager nodes are in the node repository under the Views category. On the other hand, the "String Cleaner" node can be found in the Manipulation category. You can easily download and run the workflow directly in your KNIME installation. We recommend that you use the latest version of the KNIME Analytics Platform for optimal performance. It can also be deployed as a Data App in KNIME Business Hub. The "String Format Manager" and "Number Format Manager" nodes can format strings and numbers for better visualization. The "String Cleaner" node assists in common data-cleaning tasks. Combining these nodes can create a helpful toolbox for plotting datasets on a table view. We created synthetic data to showcase the node's capabilities. It contains fake camera model information, including descriptions, reviews, and technical characteristics. The "Table View" provides a clear display of the results of data cleaning and formatting. For instance, the "Price" column shows the removal of decimals and using apostrophes as thousand separators. The camera descriptions are wrapped for convenience, and the fake links are now clickable. Additionally, we have standardized the number of decimal places to four for all columns with technical information about the cameras.

External resources

  • Synthetic Data Wikipedia
Loading deploymentsLoading ad hoc jobs

Used extensions & nodes

Created with KNIME Analytics Platform version 5.2.0
  • Go to item
    KNIME Base nodesTrusted extension

    KNIME AG, Zurich, Switzerland

    Version 5.2.0

    knime profile image
    knime
  • Go to item
    KNIME ViewsTrusted extension

    KNIME AG, Zurich, Switzerland

    Version 5.2.0

    knime profile image
    knime

Legal

By using or downloading the workflow, you agree to our terms and conditions.

KNIME
Open for Innovation

KNIME AG
Talacker 50
8001 Zurich, Switzerland
  • Software
  • Getting started
  • Documentation
  • Courses + Certification
  • Solutions
  • KNIME Hub
  • KNIME Forum
  • Blog
  • Events
  • Partner
  • Developers
  • KNIME Home
  • Careers
  • Contact us
Download KNIME Analytics Platform Read more about KNIME Business Hub
© 2025 KNIME AG. All rights reserved.
  • Trademarks
  • Imprint
  • Privacy
  • Terms & Conditions
  • Data Processing Agreement
  • Credits