Icon

SAP_​001_​Bank_​Reconciliation_​Solution

🎯 Technical Objective

To automate the monthly bank reconciliation process by dynamically reading and joining multiple files based on variable file paths and filtering criteria.

🛠️ KNIME Nodes to Use

  • File Handling & Iteration: List Files, Path to String,Table Row to Variable Loop Start

  • Data Reading: CSV Reader (configured with flow variables for file path)

  • Loop Control: Loop End

  • Data Cleaning: String Manipulation, GroupBy

  • Data Transformation & Joining: Joiner

  • Computation and Checks: Row Filter, Math Formula

  • Date Tagging: Date&Time Part Extractor, String to Date&Time

  • Output: Excel Writer (optional, for unmatched transactions)

Solution:

List Files/Folders
Table Row to Variable Loop Start
Date&Time Part Extractor
Row Splitter
Path to String
Table Row to Variable Loop Start
CSV Reader
CSV Reader
GroupBy
String Manipulation
Row Filter
Loop End
String Manipulation
Loop End
Joiner
String to Number
String Manipulation
GroupBy
String to Date&Time
Math Formula
GroupBy

Nodes

Extensions

Links