TechNet
Export (0) Print
Expand All

Fuzzy Grouping Transformation Editor (Columns Tab)

 

Applies To: SQL Server 2016

Use the Columns tab of the Fuzzy Grouping Transformation Editor dialog box to specify the columns used to group rows with duplicate values.

To learn more about the Fuzzy Grouping transformation, see Fuzzy Grouping Transformation.

Available Input Columns
Select from this list the input columns used to group rows with duplicate values.

Name
View the names of available input columns.

Pass Through
Select whether to include the input column in the output of the transformation. All columns used for grouping are automatically copied to the output. You can include additional columns by checking this column.

Input Column
Select one of the input columns selected earlier in the Available Input Columns list.

Output Alias
Enter a descriptive name for the corresponding output column. By default, the output column name is the same as the input column name.

Group Output Alias
Enter a descriptive name for the column that will contain the canonical value for the grouped duplicates. The default name of this output column is the input column name with _clean appended.

Match Type
Select fuzzy or exact matching. Rows are considered duplicates if they are sufficiently similar across all columns with a fuzzy match type. If you also specify exact matching on certain columns, only rows that contain identical values in the exact matching columns are considered as possible duplicates. Therefore, if you know that a certain column contains no errors or inconsistencies, you can specify exact matching on that column to increase the accuracy of the fuzzy matching on other columns.

Minimum Similarity
Set the similarity threshold at the join level by using the slider. The closer the value is to 1, the closer the resemblance of the lookup value to the source value must be to qualify as a match. Increasing the threshold can improve the speed of matching since fewer candidate records need to be considered.

Similarity Output Alias
Specify the name for a new output column that contains the similarity scores for the selected join. If you leave this value empty, the output column is not created.

Numerals
Specify the significance of leading and trailing numerals in comparing the column data. For example, if leading numerals are significant, "123 Main Street" will not be grouped with "456 Main Street."

ValueDescription
NeitherLeading and trailing numerals are not significant.
LeadingOnly leading numerals are significant.
TrailingOnly trailing numerals are significant.
LeadingAndTrailingBoth leading and trailing numerals are significant.

Comparison Flags
For information about the string comparison options, see Comparing String Data.

Integration Services Error and Message Reference
Identify Similar Data Rows by Using the Fuzzy Grouping Transformation

Community Additions

ADD
Show:
© 2016 Microsoft