Icon

Processing_​Statements_​Without_​Loops

Read Bank Statements


- Select file
- Set correct row as column headers

Clean up


- Remove empty columns
- Remove irrelevant or empty rows

Standardise bank statement formats

- Rename columns to be the same
- Concatenate text columns

Statement 1
Excel Reader
Statement 2
Excel Reader
Remove rowswith missing date
Row Filter (deprecated)
Remove columnswhich we don't need and empty columns
Column Filter
Remove columnswhich we don't need
Column Filter
Remove rowswith missing date
Row Filter (deprecated)
Remove rowthat is just formatting
Row Filter (deprecated)
Remove rowswith missingamount
Row Filter (deprecated)
Remove rowswith missingamount
Row Filter (deprecated)
Rename 'Amount'to 'Debit'
Column Renamer
Clean up accountnumber which hasother characters
String Manipulation
Concatenate
Put Credit andDebit in sametable
Concatenate
Rename columnsinto the unified names
Column Renamer
Ensure correcttype of numericalvalues
String to Number
Rename columnsinto the unified names
Column Renamer
Rename columnsinto the unified names
Column Renamer
Rename 'Amount #1'to 'Credit'
Column Renamer
Get debit records
Column Filter
Get credit records
Column Filter
Convert special stringdate format toKnime Date format
String to Date&Time (deprecated)
Convert special stringdate format toKnime Date format
String to Date&Time (deprecated)

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: jacobcoles
Created at: 2024-10-09
On NodePit since: 2026-06-25
Last update: 2026-06-26
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!