Validate Customer data example Workflow

Clinton Jones
Clinton Jones Experian Elite
edited December 2023 in Tips and tricks

This simple validation workflow leverages the Sample Data of Customer V1,

The FILTER step filters to just US Data

The SAMPLE step only samples 1000 rows randomly (the randomization is done only once)

The TRANSFORM steps replace _ with . for emails, reformat phones to the international standard and then generate boolean checks for all columns based on varying rules.

The VALIDATE step at the end picks up the booleans and surfaces these as rules