User Tools

Site Tools


transformations:removeemptycolumns

Differences

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

Link to this comparison view

transformations:removeemptycolumns [2018/07/22 20:27]
dmitry created
transformations:removeemptycolumns [2018/10/10 11:51] (current)
dmitry
Line 1: Line 1:
 ===== Remove empty columns ===== ===== Remove empty columns =====
  
-This action removes columns with no meaningful information ​such as empty columnscolumns ​with all values ​being whitespace, or columns where all values are the same.+This action removes columns with little or no meaningful information. It has three modes: 
 + 
 +  * **Remove columns where all values are empty values** - removes ​columns ​that only contain empty values (nulls) 
 + 
 +  * **Remove ​columns ​where 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 ​columns where all values are the same** - removes columns where all values are the same, e.g. when a column contains only text value "​N/​A"​ in all rows.
  
 The action can be helpful, for instance, after importing spreadsheets with sparsely located tables, or where table position changes from a file to file. It can also be used to remove columns that only contain null replacement values, such as "​NULL"​. The action can be helpful, for instance, after importing spreadsheets with sparsely located tables, or where table position changes from a file to file. It can also be used to remove columns that only contain null replacement values, such as "​NULL"​.
transformations/removeemptycolumns.txt · Last modified: 2018/10/10 11:51 by dmitry