Icon

03 Workflow Control

Task 1: Generic Loop Task 2: Group Loop Task 3: Switch Note: In Task 3, I tried to match the exercise with the online labs,however, there were a few errors with ports, but flow is in order # of products:Current iteration+1Filter:ProfitscolumnCalculate totalSalestotal_sales< 100Table dimensionsFiltered:price is 0Region and SalesAvg priceProfit=$0Replace $0 room pricesRemove rowswith missing valuesin group columnsStop whennumber of rowsis zeroGlobal Data Superstore.csv Math Formula(Variable) Row Filter Math Formula Row Filter Extract TableDimension Row Filter Group Loop Start GroupBy Row Splitter ConstantValue Column Missing Value Table Rowto Variable Variable ConditionLoop End Generic Loop Start CSV Reader Loop End Concatenate Component Task 1: Generic Loop Task 2: Group Loop Task 3: Switch Note: In Task 3, I tried to match the exercise with the online labs,however, there were a few errors with ports, but flow is in order # of products:Current iteration+1Filter:ProfitscolumnCalculate totalSalestotal_sales< 100Table dimensionsFiltered:price is 0Region and SalesAvg priceProfit=$0Replace $0 room pricesRemove rowswith missing valuesin group columnsStop whennumber of rowsis zeroGlobal Data Superstore.csv Math Formula(Variable) Row Filter Math Formula Row Filter Extract TableDimension Row Filter Group Loop Start GroupBy Row Splitter ConstantValue Column Missing Value Table Rowto Variable Variable ConditionLoop End Generic Loop Start CSV Reader Loop End Concatenate Component

Nodes

Extensions

Links