Both sides previous revisionPrevious revisionNext revision | Previous revisionLast revisionBoth sides next revision |
transformations:keeptop [2021/05/04 17:46] – craigt | transformations:keeptop [2021/07/19 02:12] – [Examples] craigt |
---|
\\ | \\ |
=====Use cases===== | =====Use cases===== |
Reduce the size of a 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 a 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.\\ |
| |
\\ | \\ |
\\ | \\ |
=====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) |
> 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]] |
| |