User Tools

Site Tools


transformations:filterminmax

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
transformations:filterminmax [2021/04/26 01:30] craigttransformations:filterminmax [2023/10/05 00:35] (current) – [See also] dmitry
Line 9: Line 9:
 \\ \\
 =====Use cases===== =====Use cases=====
-Use this action to generate datasets of "top N" or "bottom N" (or "top %"/"bottom %") records based on values in a specific column.+Use this action to generate datasets of "top N" or "bottom N" (or "top %" or "bottom %") records based on values in a specific column.
  
 \\  \\ 
Line 28: Line 28:
 \\  \\ 
 =====Examples===== =====Examples=====
-**Objective:** Obtain the products with the lowest three prices.\\+**Example:** Obtain the products with the lowest three prices.\\
  
 **Source table:** **Source table:**
Line 45: Line 45:
  
 \\  \\ 
-**Result:**+**Result table:**
 ^ Product ^ Price, USD ^ ^ Product ^ Price, USD ^
 |A |  12| |A |  12|
Line 52: Line 52:
 |F |   9| |F |   9|
 Although the "Count" value was "3", four rows were returned due to the duplicate value "13" in two rows.\\ Although the "Count" value was "3", four rows were returned due to the duplicate value "13" in two rows.\\
 +
 +\\ 
 +====Community examples====
 +  * [[https://community.easymorph.com/t//1332/3|String manipulation (REVERSE)]] ([[https://community.easymorph.com/uploads/short-url/67c52KIJt323kknw2Q4vOvlAJ05.morph|Project]]; Module: //Main//; Group: //Tab 1//; Table: //Using actions//; Action position: //5//)
 +  * [[https://community.easymorph.com/t//2156/1|How to process parent-child data structures]] ([[https://community.easymorph.com/uploads/short-url/zmylfn4Qr0ovzu3e5rybl0LVMNG.morph|Project]]; Module: //Module 1//; Group: //Tab 1//; Table: //Longest folder path//; Action position: //4//)
  
 \\  \\ 
 =====See also===== =====See also=====
-  * [[transformations:keeptop|Trim table]]+  * [[transformations:trimtable|Trim table]]
transformations/filterminmax.txt · Last modified: 2023/10/05 00:35 by dmitry

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki