Icon

Question2

Question2

Question2

Read the sales.csv dataset.
- 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 currencycolumn with valueUSDcreate conversioncolumnvalue 0.88 for USDvalue 1 for EURcalculate amount for EURproduct namesto numberread sales.csv Rule Engine Rule Engine Math Formula String Manipulation File Reader create currencycolumn with valueUSDcreate conversioncolumnvalue 0.88 for USDvalue 1 for EURcalculate amount for EURproduct namesto numberread sales.csv Rule 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-19
Last update: 2024-05-04
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!