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