Icon

SAP_​006_​FX

🎯 Technical Objective

To convert transaction amounts to a base currency (USD) by dynamically applying foreign exchange rates based on the transaction currency.

🛠️ KNIME Nodes to Use

  • Data Aggregation: GroupBy

  • Loop Control: Table Row to Variable Loop Start

  • Loop End

  • Conditional Logic: Rule Engine

  • Data Transformation: Math Formula

  • Column Expressions

  • Variable Manipulation: Variable Expressions

  • Table Creator (to simulate FX lookup)

Solution:

CSV Reader
GroupBy

Nodes

Extensions

Links