Icon

SAP_​005_​FinCon

🎯 Technical Objective

To consolidate multiple departmental Excel financial reports into a single, unified report, handling varying report structures and dynamically extracting data.

🛠️ KNIME Nodes to Use

  • File Handling & Iteration: List Files

  • Table Row to Variable Loop Start

  • Data Reading: Excel Reader (configured with flow variables)

  • Data Transformation: Pivoting

  • Column Filter

  • Column Renamer

  • Constant Value Column

  • Data Aggregation: Concatenate

  • GroupBy

  • Output: Excel Writer

Solution:

Nodes

  • No nodes found

Extensions

  • No modules found

Links