Process data in groups: Using a loop and flow variables
This workflow example demonstrates how to process data in groups using a loop and flow variables.
After accessing the sample data, first the two metrics “Sales Performance” and “Sales Gap” are calculated using the Expression node. Next, based on the "Sales Gap", the "Performance Status" is derived by defining a logic using the Rule Engine node. Using the Group Loop Start node, the data is now processed in groups by "Region" and "Performance Status" and then eventually saved as separate Excel files using the Excel Writer node.
The sample data has 5 columns:
Product ID: Each product's number
Region: North America, South America, Europe, or Asia
Sales Date: The transaction date
Sales Amount: The amount of each transaction
Target Sales: The target amount for each transaction