Icon

hw3_​Q2

read sales.csv fileadd a new column that is "currency" with USD value for USA and EUR value for Germanyadd a new column that is "conversion" with value 1 if currency is EUR and 0.88 if currency is USDadd a new column that is "amount-in-EUR" and it show multiplying the value in column “amount” by the value in column “conversion"clear number(1,2,3 etc)"prod_number" in product columnFile Reader Rule Engine Rule Engine Math Formula String Manipulation read sales.csv fileadd a new column that is "currency" with USD value for USA and EUR value for Germanyadd a new column that is "conversion" with value 1 if currency is EUR and 0.88 if currency is USDadd a new column that is "amount-in-EUR" and it show multiplying the value in column “amount” by the value in column “conversion"clear number(1,2,3 etc)"prod_number" in product columnFile Reader Rule Engine Rule Engine Math Formula String Manipulation

Nodes

Extensions

Links