14,970
edits
Data cleaning: Difference between revisions
Jump to navigation
Jump to search
→check if field value was not fulfilled
| Line 1: | Line 1: | ||
== check if field value was not fulfilled == | == check if field value was not fulfilled == | ||
=== | === by purpose === | ||
<table border="1" style="width: 100%"> | |||
<tr style="background-color: #555555; color: #ffffff;"> | |||
<td>purpose</td> | |||
<td>method</td> | |||
<td>value1: <br />fulfilled value what I want</td> | |||
<td>value2: <br />fulfilled value NOT I want</td> | |||
<td>value3: <br />0 value</td> | |||
<td>value4: <br />NULL value</td> | |||
<td>value5: <br />empty or spaces value</td> | |||
</tr> | |||
<tr> | |||
<td>find not fulfilled or empty values <br />(not contains 0)</td> | |||
<td>WHERE column_name IS NULL OR LENGTH(TRIM( column_name )) = 0</td> | |||
<td></td> | |||
<td></td> | |||
<td></td> | |||
<td>V</td> | |||
<td>V</td> | |||
</tr> | |||
<tr> | |||
<td>find not fulfilled or empty values <br />(contains 0)</td> | |||
<td></td> | |||
<td></td> | |||
<td></td> | |||
<td>V</td> | |||
<td>V</td> | |||
<td>V</td> | |||
</tr> | |||
<tr> | |||
<td>find fulfilled and non-empty values <br />(not contains 0)</td> | |||
<td></td> | |||
<td>V</td> | |||
<td>V</td> | |||
<td></td> | |||
<td></td> | |||
<td></td> | |||
</tr> | |||
<tr> | |||
<td>find fulfilled and non-empty values <br />(contains 0)</td> | |||
<td>WHERE LENGTH(TRIM( column_name )) > 0</td> | |||
<td>V</td> | |||
<td>V</td> | |||
<td>V</td> | |||
<td></td> | |||
<td></td> | |||
</tr> | |||
<tr> | |||
<td>find not fulfilled or empty values <br />(not contains 0 & values NOT I want)</td> | |||
<td></td> | |||
<td></td> | |||
<td>V</td> | |||
<td></td> | |||
<td>V</td> | |||
<td>V</td> | |||
</tr> | |||
</table> | |||
=== by datatype === | |||
<table border="1" style="width: 100%"> | <table border="1" style="width: 100%"> | ||
<tr style="background-color: #555555; color: #ffffff;"> | <tr style="background-color: #555555; color: #ffffff;"> | ||