-
Is there a Zip code validation Regex code library?
Hi All, We need to check and validate the Postal codes in our database for all the countries and I see that we have these built-in format validations for these countries: Do you know if there is a library in Aperture for regex codes to check the Postal code format for all the countries? Many thanks! Kind regards, Vera
-
Joining to Validate Function, but keep Validation Formatting
Hi, I have a Validation step, it works perfectly. However, I want to append an additional column via join. When I apply the join the Validation functionality (i.e. status changing colour, drill down to see rules no long available). Is there a way to join without losing that functionality. Or maybe some hack? What I am…
-
Uniqueness and/or Completeness as a validation rule
Hi, I know we have the profile step and the validation step in a workflow, but how can I create a validation rule for uniqueness / completeness so that the results are in the validate step results. thanks
-
ℹ How to track DQ issues with Issue lists
Issue lists allow you to capture problematic records, assign them to stakeholders and collaborate on a resolution. Records that have been fixed will automatically be resolved. Setting up your Issues list Go to Issue lists in left nav bar and create a new list to track related issues Create a Workflow to write issues to the…
-
Is there an function to identify extra spaces between words?
Hi, I would like to check if is there any out of box solution for identification of extra spaces between words. Thanks
-
Suggest Validation rules - Validate step
Aperture Data Studio has a Validate workflow step that allows you to define rules of how data in specific columns should be populated. This information can then be used to be alerted to any data quality problems or to track data quality improvements over time. These rules can be simple: should not be null should be a…
-
📽 📺 Achieve more with your data - videos
On the Data Studio homepage there is a widget named 'Achieve more with your data' that gives access to some short (5-7 min) videos showing how to complete useful actions within the product. In case you cannot access these videos within the product they are listed below: Video #1 – Profiling in Data Studio…
-
🎞 A Short Feature Demo on trending your data validation results in Data Studio
-
🎞 A Short Feature Demo on data validation in Data Studio
https://bcove.video/3hw8COt
