Extract Data for the Country with Highest Sold Items using Flow Variables.
Extract data from the country with the highest number of sold items. It is easy to find the country with the highest number of sold items with: - a GroupBy node to calculate the number of sold items as sum(Quantity) by country; - then a Sorter node to sort the countries by decreasing number of sold items; - and finally a Row Filter node to extract only the first row (country) from the sorted list. Such country name now needs to be converted into the Value of a Flow Variable to overwrite the setting in the Row Filter node that extracts the data fro a given country. The necessary node here is TableRow To Variable. To consume a Flow Variable (that is to overwrite a configuration setting with the flow variable value) you can use: - the flow variable button on the side of the configuration setting - the Flow Variables tab in the node configuration window.