Icon

flow variable demo

Flow Variables - Solution

Solution to the exercise 7 for KNIME User Training
- Filtering rows by an attribute value
- Filtering rows by an attribute value that fulfils a condition and that is updated automatically
- Filtering rows based on a user selection
- Creating a component

Flow Variable Demo1. Read the customer data 2. Row Filter to filter Gold Investment3. Find the most popular product - GroupBy, group by Products, counts for each product4. Sort the aggregation table descendingly (Sorter), with the most popular product at the top5. Convert the first row to flow variables6. Use the flow variable to select the most poular category in the Row Filter Activity IV: Flow Variables (optional)Goal: Create a component that allows to select multiple products out of all available products, using a flow variable of type array1. Remove all columns besides the column Products (Column Filter node)2. Remove duplicate rows (Duplicate Row Filter node)3. Transpose the column (Transpose node)4. Aggregate all products into one Cell (Create Collection Column node)5. Create an array flow variable with all products(Table Row to Variable node)6. Create an input option to select multiple products (Multiple Selection Configuration node) Tip: Control the setting option "Possible Choices" via the Flow Variable tab by using the flow variable created in step 5 filter by Productsby Productsfirst rowCustomer datadesc by countSet executiondateJoin nameand execution dateCreate pathflow variableWrite product typewith execution dateCustomer dataOnly products columnEach productonly onceAggregate valuesin arrayCustomer data Row Filter GroupBy Table Rowto Variable Table Reader Sorter Date&TimeConfiguration String Manipulation(Variable) Create File/FolderVariables CSV Writer Select Product Type Table Reader Column Filter DuplicateRow Filter Create CollectionColumn Table Rowto Variable Transpose Multiple SelectionConfiguration Table Reader ReferenceRow Filter Select Products Flow Variable Demo1. Read the customer data 2. Row Filter to filter Gold Investment3. Find the most popular product - GroupBy, group by Products, counts for each product4. Sort the aggregation table descendingly (Sorter), with the most popular product at the top5. Convert the first row to flow variables6. Use the flow variable to select the most poular category in the Row Filter Activity IV: Flow Variables (optional)Goal: Create a component that allows to select multiple products out of all available products, using a flow variable of type array1. Remove all columns besides the column Products (Column Filter node)2. Remove duplicate rows (Duplicate Row Filter node)3. Transpose the column (Transpose node)4. Aggregate all products into one Cell (Create Collection Column node)5. Create an array flow variable with all products(Table Row to Variable node)6. Create an input option to select multiple products (Multiple Selection Configuration node) Tip: Control the setting option "Possible Choices" via the Flow Variable tab by using the flow variable created in step 5 filter by Productsby Productsfirst rowCustomer datadesc by countSet executiondateJoin nameand execution dateCreate pathflow variableWrite product typewith execution dateCustomer dataOnly products columnEach productonly onceAggregate valuesin arrayCustomer data Row Filter GroupBy Table Rowto Variable Table Reader Sorter Date&TimeConfiguration String Manipulation(Variable) Create File/FolderVariables CSV Writer Select Product Type Table Reader Column Filter DuplicateRow Filter Create CollectionColumn Table Rowto Variable Transpose Multiple SelectionConfiguration Table Reader ReferenceRow Filter Select Products

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: knime
Created at: 2014-02-07
On NodePit since: 2023-01-25
Last update: 2024-04-27
Created with KNIME version: v4.7.0
Tags: flow variableconfigurationworkflow automationworkflow controlworkflow abstractioncomponentuser selectionparameterizationeducation

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!