Icon

Processing_​Statements_​With_​Loops

Clean up


- Remove empty columns
- Remove irrelevant or empty rows

Standardise bank statement formats

- Rename columns to be the same
- Concatenate text columns

Read all files and extract format

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
Put Credit andDebit in sametable
Concatenate
Rename columnsinto the unified names
Column Renamer
Rename 'Amount #1'to 'Credit'
Column Renamer
Excel Reader
Allows usto see thecolumn names
Extract Table Spec
Get list of filesto process
List Files/Folders
Table Row to Variable Loop Start
Allows us to aggregateto see if any of the columnscontained thesubstring "empty"
GroupBy
Rename to port-select
Column Renamer
Output if the columnnames containthe substring"empty" or not(Allows us to identifythe format 1 or 2)
Expression
Clean up accountnumber which hasother characters
String Manipulation
Fix the rightrow as the columnnames
Row to Column Names
Rename columnsinto the unified names
Column Renamer
Ensure correcttype of numericalvalues
String to Number
CASE Switch End
Access the portselection as flow-variablewhich will control the case switch
Table Row to Variable
Rename columnsinto the unified names
Column Renamer
Must select the variableport-select as the portselection
CASE Switch Start
Get debit records
Column Filter
Get credit records
Column Filter
Convert special stringdate format toKnime Date format
String to Date&Time (deprecated)
Concatenates resultsfrom all files
Loop End
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!