User Tools

Site Tools


transformations:cleanup

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
Next revisionBoth sides next revision
transformations:cleanup [2021/03/30 22:18] craigttransformations:cleanup [2021/07/15 11:30] craigt
Line 5: Line 5:
 \\  \\ 
 =====Description===== =====Description=====
-This action removes specified values, or values of a particular type (e.g. text), from a column by replacing them with empty cells. +This action removes specified values, or values of a particular type (e.g. text), from a column by replacing them with empty cells.\\
- +
-Unlike [[transformations:selectionfilter|Filter]], this transformation doesn't remove table rows. +
- \\+
  
 \\ \\
Line 29: Line 26:
 |Remove errors|All error results are removed.| |Remove errors|All error results are removed.|
 |Remove particular values|Options:  //Remove selected values// or //Remove all but selected// When selected, a list of all unique\\ values in the column is displayed for the user to manually select which values to keep or remove.| |Remove particular values|Options:  //Remove selected values// or //Remove all but selected// When selected, a list of all unique\\ values in the column is displayed for the user to manually select which values to keep or remove.|
 +
 +\\ 
 +=====Remarks=====
 +Unlike [[transformations:selectionfilter|Filter]], this transformation doesn't remove table rows.\\
 +
 +\\ 
 +=====Community examples=====
 +  * [[https://community.easymorph.com/t//1375/5|Example: Getting public holidays from an API with Web Request]] ([[https://community.easymorph.com/uploads/short-url/pL0iYCFfb1g8rGHfNBMZd1rAd8k.morph|Project]]; Module: //Main//; Group: //Tab 1//; Table: //Public holidays//;\\ Action position: //4//)
 +  * [[https://community.easymorph.com/t//2017/3|Duplicating rows based on a condition]] ([[https://community.easymorph.com/uploads/short-url/blETeOO6qUVzskyO2eYqMiNvjPP.morph|Project]]; Module: //Main//; Group: //Tab 1//; Table: //Table 1 (2)//; Action position: //5//)
  
 \\  \\ 
transformations/cleanup.txt · Last modified: 2024/04/12 00:35 by craigt

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki