Icon

Excel & KNIME

5 workflows in this folder and its subfolders

Icon
Data manipulation example

September 2019 · Data manipulation example KNIME provides a variety of nodes to apply formulas and expressions across different data types, enabling users to calculate, manipulate, and transform data. This example workflow showcases various nodes to manipulate string values, transform numeric values, and generate ne…

Icon
Date & time operations

URL: KNIME Blog: Explore Date&Time in KNIME & Get Best Practices https://www.knime.com/blog/explore-date-time-formats-best-practices URL: KNIMETV: Handling Date & Time Data with KNIME: Convert Strings and Extract Date & Time Fields https://youtu.be/3qtKNSeGbms?si=5anbUCrGMbLT90Gc URL: KNIMETV: Handl…

Icon
Read all sheets from an Excel file

May 2016 · Read all sheets from an Excel file in a loop This workflow demonstrates how to read all sheets from an Excel (.xlsx) file using the Excel Reader node together with the Read Excel Sheet Names node in a loop. To read all sheets from an .xlsx file, first add the Read Excel Sheet Names node to the works…

Icon
Sales analysis data app

URL: SuperStore dataset https://www.kaggle.com/datasets/timchant/supstore-dataset-2019-2022/data

Icon
Workflow control - Process data in groups

Process data in groups: Using a loop and flow variables This workflow example demonstrates how to process data in groups using a loop and flow variables. After accessing the sample data, first the two metrics “Sales Performance” and “Sales Gap” are calculated using the Expression node. Next, based o…