New reply on DataCleaner's online discussion forum (https://datacleaner.org/forum):
Dennis replied to subject 'Q: How can I create a consistency check across fields in a dataset...' ------------------- Hi Steen, I'm not sure if I'm reading it right, but I guess by "IF (A1)" etc., you mean if there is a value in there, or do you mean if it is a truthy value (1, true, yes, etc.)? I'll assume the first in this reply. In theory this should be doable with a combination of null check filters (which can cut across fields) and coalesce transformers, but that could easily become a mess, especially since combinations of filters can be a bit non-intuitive at times. You could take a look at the JavaScript filter, where you can specify more complex rules programmatically, or if it is something you need to do often on different datastores, maybe even create a custom filter, which would be a more configurable. This would indeed be a good idea to make easier in general, so I'll add it as a suggestion for the null-check filter... The hard part is making sure the simple "are all set?" case is not made much harder by supporting the more complex case. Best regards, Dennis ------------------- View the topic online to reply - go to https://datacleaner.org/topic/1138/Q%3A-How-can-I-create-a-consistency-check-across-fields-in-a-dataset... -- You received this message because you are subscribed to the Google Groups "DataCleaner-notify" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/datacleaner-notify. For more options, visit https://groups.google.com/d/optout.
