User Tools

Site Tools


transformations:keeptop

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
Last revisionBoth sides next revision
transformations:keeptop [2021/05/04 17:46] craigttransformations:keeptop [2021/07/19 02:12] – [Examples] craigt
Line 9: Line 9:
 \\ \\
 =====Use cases===== =====Use cases=====
-Reduce the size of larger dataset to a specific number of rows during the initial build of a workflow.  Remove the //Trim table// action when the workflow is complete, to process the entire dataset.+Keep only the top N significant items (e.g. top 10 products by sales volume) for report or dashboard.
  
-Remove extraneous metadata from the top or bottom of a dataset.\\+Reduce the size of a larger dataset to a specific number of rows during the initial build of a workflow.  Remove or disable the //Trim table// action when the workflow is complete, to process the entire dataset.
  
 +Remove extraneous metadata from the top or bottom of a dataset.\\
  
 \\  \\ 
Line 24: Line 25:
 \\  \\ 
 =====Examples===== =====Examples=====
-**Objective:** Keep the top three longest rivers.\\+**Example:** Keep the top three longest rivers.\\
 \\  \\ 
 **Table:** The longest rivers in the world (in descending order by length) **Table:** The longest rivers in the world (in descending order by length)
Line 42: Line 43:
 > Number of rows is "3" > Number of rows is "3"
 \\  \\ 
-**Result:**+**Result table:**
 ^River  ^Length (km)  ^Continent  ^ ^River  ^Length (km)  ^Continent  ^
 | Nile  |  6650|Africa  | | Nile  |  6650|Africa  |
 | Amazon  |  6400|South America  | | Amazon  |  6400|South America  |
 | Yangtze  |  6300|Asia  | | Yangtze  |  6300|Asia  |
 +
 +\\ 
 +====Community examples====
 +  * [[https://community.easymorph.com/t//1312/2|A way to obtain all positions of a char in text]] ([[https://community.easymorph.com/uploads/short-url/2lIBiIZXyCaizzyOl1nTkfleYfL.morph|Project]]; Module: //Main//; Group: //Tab 1//; Table: //Table 2//; Action position: //3//)
 +  * [[https://community.easymorph.com/t//1870/4|Send email - Add table extract to outlook email message]] ([[https://community.easymorph.com/uploads/short-url/xnfDuDCTN6iJgA4pEcQQsRIZET3.morph|Project]]; Module: //Main//; Group: //Tab 1//; Table: //Input dataset with prepended headers row//; Action position: //2//)
 +  * [[https://community.easymorph.com/t//1972/2|Read Data with two line header]] ([[https://community.easymorph.com/uploads/short-url/4YFQxslIv3pmgtF2eRywf4wpcFQ.morph|Project]]; Module: //Main//; Group: //Tab 1//; Table: //Read, Mark groups//; Action position: //2//)
 +  * [[https://community.easymorph.com/t//2185/4|Transform parsed JSON to right format]] ([[https://community.easymorph.com/uploads/short-url/z1JsbbyueYletNwNg1VlSef2C4C.morph|Project]]; Module: //Main//; Group: //Group 1//; Table: //Imported table 1.dset//; Action position: //4//)
  
 \\  \\ 
 =====See also===== =====See also=====
   * [[transformations:keepremovematching|Keep/remove matching]]   * [[transformations:keepremovematching|Keep/remove matching]]
 +  * [[transformations:trimbycondition|Trim table by condition]]
  

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki