User Tools

Site Tools


transformations:removeemptyrows

Differences

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

Link to this comparison view

Next revision
Previous revision
transformations:removeemptyrows [2019/09/08 18:52] – created dmitrytransformations:removeemptyrows [2021/07/19 02:20] (current) – [Examples] craigt
Line 1: Line 1:
-===== Remove empty rows =====+{{ transformations:RemoveEmptyRowsAction.png}} 
 +====== REMOVE EMPTY ROWS ====== 
 +Category: Transform / Advanced\\
  
-Category: Transform Advanced.+\\  
 +=====Description===== 
 +This action removes empty rows or rows that //appear// empty, and have no meaningful information (e.g. whitespace values). For convenience, certain columns can be ignored if they have non-empty values which are not necessary.\\
  
-This action removes empty rows, or rows that don't look empty and don't have any meaningful information (e.g. whitespace values). For convenience, certain columns can be ignored if they have non-empty values which are not necessary.+\\  
 +=====Use cases===== 
 +The action can be convenient for removing empty rows without using a filter. When empty rows are removed using a filter applied to 1 or several columns there is always a risk that important data may reside in columns not included in the filters and thus accidentally removed. The //Remove empty rows// action reduces this risk and guarantees that only rows without meaningful information will be removed.\\
  
-**Example**+\\  
 +=====Action settings===== 
 +====Remove empty rows where settings==== 
 +^Setting^Description^ 
 +|All values are empty values|Removes columns that only contain empty values (nulls)| 
 +|All values are empty or whitespace|Removes columns that contain either empty or whitespace values (e.g. values with only spaces, line breaks, or tabs but no visible characters).| 
 +\\  
 +====Remove empty rows settings==== 
 +^Setting^Description^ 
 +|Top|When checked, all empty rows from the start of the dataset (row 1) to the first non-empty row are removed.| 
 +|Between the first and last non-empty row|When checked, all empty rows in the middle of the dataset - between the first non-empty row, and the last non-empty row - are removed .| 
 +|Bottom|When checked, all empty rows from the end of the dataset (last row) up to the last non-empty row are removed.| 
 +\\  
 +====Ignore columns (optional) settings==== 
 +Select from the list which columns' values are ignored when determining when to remove the row or not.  In other words, all values within the selected column(s) will be treated as //empty//.\\
  
-Source dataset: +\\  
-^ Product name  ^ Qty ^ Price ^ Note ^+=====Remarks===== 
 +When using the //Ignore columns// option, note that if columns contain values, but the rest of the columns are columns are blank (for any given record), the rows will be removed and data in these columns will be removed.  Use this setting when columns contain static values, or perhaps annotations, that are not relevant if the rest of the rows' data is blank.\\ 
 + 
 +\\  
 +=====Examples===== 
 + 
 +**Example:** Remove empty rows, ignore column [Note].\\ 
 + 
 +**Source dataset:** 
 +^ Product name  ^ Qty  ^ Price  ^ Note  ^
 | Big thing        1|   1000|      | | Big thing        1|   1000|      |
 |                         |No data here |  |                         |No data here | 
 | Medium thing  |   10|    100|      | | Medium thing  |   10|    100|      |
 | Small thing    100|     10|      | | Small thing    100|     10|      |
- +\\  
-Objectiveremove empty rows, ignore column [Note]+**Action parameters:** 
- +> //Remove rows where// can be either setting in this example. 
-Result: +> "Between the first and last non-empty rows" is "checked"
-^ Product name ^ Qty ^ Price ^ Note ^+> "Ignore columns":  "Note" is selected
 +\\  
 +**Result table:** 
 +^ Product name  ^ Qty  ^ Price  ^ Note  ^
 | Big thing        1|  1000|      | | Big thing        1|  1000|      |
 | Medium thing  |   10|   100|      | | Medium thing  |   10|   100|      |
 | Small thing    100|    10|      | | Small thing    100|    10|      |
  
-**Use cases** +\\  
- +====Community examples==== 
-The action can be convenient for removing empty rows without using a filterWhen empty rows are removed using a filter applied to or several columns there is always a risk that important data may reside in columns not included in the filters and thus accidentally removedThe "Remove empty rows" action reduces this risk and guarantees that only rows without meaningful information will be removed+  * [[https://community.easymorph.com/t//1499/2|Data cleaning for data spread over multiple rows and columns]] ([[https://community.easymorph.com/uploads/short-url/kgmVTEHcl0CE7Yep5uzuGW1HLKc.morph|Project]]; Module: //Main//; Group: //Tab 1//; Table: //Table 1(2)//;\\ Action position: //3//) 
- +  * [[https://community.easymorph.com/t//2053/9|Converting Text to HTML]] ([[https://community.easymorph.com/uploads/short-url/3acTPpAroyvp3DsTPNTOZQIqaHO.morph|Project]]; Module: //Main//; Group: //Tab 1//; Table: //Table 1//; Action position: //2//) 
-**See also**+  [[https://community.easymorph.com/t//2389/1|How to query Salesforce using EasyMorph 4.6]] ([[https://community.easymorph.com/uploads/short-url/23kUESqob17X4cG2jbjXPaM8477.morph|Project]]; Module: //Query Salesforce//; Group: //Group 1//; Table: //Iterate & Cleanup Salesforce collection//; Action position: //10//)
  
 +\\ 
 +=====See also=====
   * [[transformations:removeemptycolumns|Remove empty columns]]   * [[transformations:removeemptycolumns|Remove empty columns]]
 +
transformations/removeemptyrows.1567983126.txt.gz · Last modified: 2019/09/08 18:52 by dmitry

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki