14,959
edits
Data cleaning: Difference between revisions
Jump to navigation
Jump to search
m
→by purpose
m (→by purpose) |
|||
| 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%"> | <table border="1" style="width: 100%"> | ||
<tr style="background-color: #555555; color: #ffffff;"> | <tr style="background-color: #555555; color: #ffffff;"> | ||
| Line 13: | Line 13: | ||
</tr> | </tr> | ||
<tr> | <tr> | ||
<td> | <td>values were not fulfilled or empty <br />(not contains 0)</td> | ||
<td>{{kbd | key=<nowiki>WHERE column_name IS NULL OR LENGTH(TRIM( column_name )) = 0</nowiki>}}</td> | <td>{{kbd | key=<nowiki>WHERE column_name IS NULL OR LENGTH(TRIM( column_name )) = 0</nowiki>}}</td> | ||
<td></td> | <td></td> | ||
| Line 22: | Line 22: | ||
</tr> | </tr> | ||
<tr> | <tr> | ||
<td> | <td>values were not fulfilled or empty<br />(contains 0)</td> | ||
<td></td> | <td></td> | ||
<td></td> | <td></td> | ||
| Line 31: | Line 31: | ||
</tr> | </tr> | ||
<tr> | <tr> | ||
<td> | <td>values were fulfilled and non-empty<br />(not contains 0)</td> | ||
<td></td> | <td></td> | ||
<td>V</td> | <td>V</td> | ||
| Line 40: | Line 40: | ||
</tr> | </tr> | ||
<tr> | <tr> | ||
<td> | <td>values were fulfilled and non-empty<br />(contains 0)</td> | ||
<td>{{kbd | key=<nowiki>WHERE LENGTH(TRIM( column_name )) > 0</nowiki>}}</td> | <td>{{kbd | key=<nowiki>WHERE LENGTH(TRIM( column_name )) > 0</nowiki>}}</td> | ||
<td>V</td> | <td>V</td> | ||
| Line 49: | Line 49: | ||
</tr> | </tr> | ||
<tr> | <tr> | ||
<td> | <td>values (1) were not fulfilled or empty values (2) NOT I want <br />(not contains 0)</td> | ||
<td>{{kbd | key=<nowiki>WHERE column_name IS NULL OR LENGTH(TRIM( column_name )) = 0 OR column_name LIKE 'values NOT I want'</nowiki>}}</td> | <td>{{kbd | key=<nowiki>WHERE column_name IS NULL OR LENGTH(TRIM( column_name )) = 0 OR column_name LIKE 'values NOT I want'</nowiki>}}</td> | ||
<td></td> | <td></td> | ||
| Line 58: | Line 58: | ||
</tr> | </tr> | ||
<tr> | <tr> | ||
<td> | <td>values (1) were not fulfilled or empty values (2) NOT I want <br />(contains 0)</td> | ||
<td></td> | <td></td> | ||
<td></td> | <td></td> | ||