Column Profile Options
When you create a profile, you can use the profile wizard to define filter, rule, and sampling options. These options determine how the profile reads rows from the data set.
The following image shows a sample filter definition in a profile:
The rule can have the business logic to perform data transformation operations on the data before column profiling.
The following image shows a rule titled Rule_FullName that merges the LastName and FirstName columns into the Fullname column:
