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
Tagged:
0
Answers
Hi James
You could feed the Profile results into a validate step and create a rule that column must be 100%
You should try Suggest validation: "The easiest way to get started is to Explore your data, Profile the desired columns and then use the Suggest validation rules action." https://docs.experianaperture.io/data-quality/aperture-data-studio-v2/get-started/create-a-workflow/#validate which will suggest is not null Function where it is appropriate based on data.
thanks, but I don't get have the "Suggest validation rules" action after I profile the data.
Steps to use Suggest validation rules:
https://community.experianaperture.io/discussion/693/suggest-validation-rules-validate-step
Copying rules between Workflows:
https://community.experianaperture.io/discussion/comment/1732
Thanks, I did find those step instructions earlier. So what I found is, the "Suggest validation rules" step does not appear if the explore step is taken within an existing workflow. Are there plans to change this? Thanks
Yes making it more discoverable is on the roadmap, no ETA at this time