Icon

05_​Flow_​Variables - Solution

05_Flow_Variables - Solution
Exercise Flow Variables1) Read data sales_data.csv2) Filter the orders to those coming from Germany3) Export the current setting “Germany” as a flow variable called “country”4) Read data orders_daily.csv, and use the “country” flow variable to filter the records5) Use the Integer Configuration node to define a lower limit for the amount of items per order. Setthe default value to 6. 6) Use this flow variable to exclude daily orders with 6 or less items Read data sales_data.csvOrders fromGermanyRead data orders_daily.csvOrders fromGermanyDefine a lower limit forthe amount of items perorder with the default = 6 Exclude daily orderswith 6 or less items File Reader Row Filter File Reader Row Filter IntegerConfiguration Row Filter Exercise Flow Variables1) Read data sales_data.csv2) Filter the orders to those coming from Germany3) Export the current setting “Germany” as a flow variable called “country”4) Read data orders_daily.csv, and use the “country” flow variable to filter the records5) Use the Integer Configuration node to define a lower limit for the amount of items per order. Setthe default value to 6. 6) Use this flow variable to exclude daily orders with 6 or less items Read data sales_data.csvOrders fromGermanyRead data orders_daily.csvOrders fromGermanyDefine a lower limit forthe amount of items perorder with the default = 6 Exclude daily orderswith 6 or less itemsFile Reader Row Filter File Reader Row Filter IntegerConfiguration Row Filter

Nodes

Extensions

Links