Icon

Solution2

Solution 2

Solution 2

• Using the Rule Engine node, create a new column “currency” with value “USD” for the orders
from the USA, and “EUR” for the orders from Germany.
• Using the Rule Engine node, create a new column “conversion” with value 1 if currency is
“EUR”, and 0.88 if currency is “USD” (we refer to the exchange rate of Nov-04-2018).
• Using the Math Formula node, calculate values in a new column named “amount-in-EUR” by
multiplying the value in column “amount” by the value in column “conversion”.
The product names are of type “prod_1”. Using the String Manipulation node, change the product
names to “1”, “2”, and so on.

create currencycolumnUSD-EURcreate conversioncolumn0.88 for USD1 for EUREUR amount product string clipread sales.csvRule Engine Rule Engine Math Formula String Manipulation File Reader create currencycolumnUSD-EURcreate conversioncolumn0.88 for USD1 for EUREUR amount product string clipread sales.csvRule Engine Rule Engine Math Formula String Manipulation File Reader

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: byasar
Created at: 2020-04-11
On NodePit since: 2020-04-24
Last update: 2024-05-03
Created with KNIME version: v4.1.1

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!