Question2

0 ×

Question2

Kubilay Sarıbardak
Homework1 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.

Nodes

• Rule Engine2 ×
• File Reader1 ×
• Math Formula1 ×
• String Manipulation1 ×

Extensions

• FeatureKNIME Base nodes
• FeatureKNIME Javasnippet
• FeatureKNIME Math Expression (JEP)

Links

• No links available