Using Data from Joined Tables to Get Greatest Value
- 12 Mar 2021
- 1 Minute to read
- Print
- DarkLight
Using Data from Joined Tables to Get Greatest Value
- Updated on 12 Mar 2021
- 1 Minute to read
- Print
- DarkLight
Article summary
Did you find this summary helpful?
Thank you for your feedback
Example Lab Article
While Example Lab projects are resources for public use, articles and assets are not actively maintained. Screenshots and features are from the specified version below. These references may become dated as new versions are released.
Overview
Example Lab Details | |
| Version | 6.5.0 |
| Root Folder | Example Lab - Greatest Value of Joined Table Group Step |
| Modules | None |
| Dependencies | None |
This Example Lab demonstrates how to create two lists of data types and compare the largest data entries of the two.
Explanation
Using the Create Data step, this creates two small samples list of two different data types. TableOne holding values and IDs, and TableTwo for the names associated with those IDs. Then the flow iterates through TableOnes values with the For Each Group Step based off of TableTwo's IDs. Then For Each value in the grouping, add them to a Sum list. Afterwards the Flow uses a Sort Array step to sort based off of the Sum in descending order and store the top value with its associated data to the resulting list. Repeat this for the next group and return the resulting list.
Reference Articles
[ARTICLES GO HERE. USE THE LINK ICON AT THE TOP OF THE EDITOR TO MASK THE URL WITH TEXT. ONE LINK PER LINE VERTICALLY.]
.png)
Project Download
The examples attached were developed to be instructional and were not developed as officially supported components. For more information or to engage our service team to develop fully supported, production quality solutions, please contact services@decisions.com. Import the project below to a Decisions environment on version 6.5.0 or later using our Importing/Exporting article.
Was this article helpful?
