MetaData Data Cleaning

From All n One's bxp software Wixi

Jump to: navigation, search

It is possible to use MetaData to auto clean data when it is loaded. When using this data for deduping or trying to perform comparisons, there are a number of rules that can be applied in order.


Metadata Rules and Process:


  1. Select all records in the campaign with the status "Received from web site"
  2. For each of the selected records perform the following:-
    1. Check the first name field and if it contains "test", flag the record as not valid
    2. Check the surname field and if it contains "test", flag the record as not valid
    3. Check the contact number field and if its blank, flag the record as not valid
    4. Check the contact number field and if it contains less than 7 characters, flag the record as not valid
    5. Check the mobile number field and if its blank, flag the record as not valid
    6. Check the mobile number field and if it contains less than 10 characters, flag the record as not valid
    7. Check the email address and if its not a valid address, flag the record as not valid


We can help you build these rules. Just give our support team a shout to help make all your programs work as best they can for you.