This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Are there help entries providing best practices for normalizing data? Typically data comes in somewhat non-normalized, records with duplicate (non-unique) or empty values. Take as an example, the following table, Grocery_Shopping:DayQtyItemTypeMon4...
I created a table called Items (household items). In Items, there is a partially filled-out field, PurchaseDate, that is some items have a PurchaseDate; other items don't have a Purchase Date (field is left blank). I want to run a filter of those i...
Hi Arthur,Thanks for your response. In a small table with not much data, manually designating characteristics of the data is possible, as you suggest, but as the data set gets quite large (imagine expanding columns to include the Buyer; Name_of_Reta...
Sho, Filtering date fields with "is empty" does do the trick. Forgot to croll al the way down to find that option! (How embarrassing!) Thanks for your tips.
DATESTR() seems not to be able to handle empty sets nicely, but BLANK() does, so instead of LEN(DATESTR()), here's what I found does work:IF({PurchaseDate} = BLANK(), "hasNoDate", "hasDate"). If the name of the field name is hasPurchaseDate, then IF(...
