Uniqueness and/or Completeness as a validation rule

James T Sidebotham

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

Josh Boxer

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.

James Sidebotham

thanks, but I don't get have the "Suggest validation rules" action after I profile the data.

Josh Boxer

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

James Sidebotham

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

Josh Boxer

Yes making it more discoverable is on the roadmap, no ETA at this time