Fuzzy Grouping Column Mapping Element
Attributes
| Attribute | API Type | Default | Description |
|---|---|---|---|
| SourceColumn | String | This value specifies the name of the source column in the data flow path mapping. This is a required property | |
| GroupOutputAlias | String | This value provides a descriptive replacement name for the automatically generated name of the output column that contains the canonical value for the grouped duplicates. | |
| IsUsed | Boolean | True | This value specifies whether the dataflow column is used. |
| MatchType | FuzzyGroupingMatchType | Fuzzy | This value specifies how the Fuzzy Grouping component will handle this column comparison. The default is to perform a Fuzzy match. |
| MinSimilarity | Int32 | 80 | This value specifies the minimum similarity threshold, expressed as a value between 0 and 100. The default value is 80. |
| Numerals | FuzzyGroupingTransformNumeralOption | Neither | This value specifies whether leading and/or trailing numerals are considered in the comparison. The default is Neither. |
| SimilarityOutputAlias | String | This value specifies a name for an output column that will contain similarity scores for the selected score. If this value is empty, the output column will not be created. | |
| SortKeyPosition | Int32 | 0 | This value specifies where the parent column is situated in the sort order. For example if the rows were first sorted by 2 other columns, then the value would be 3. If this column was not used for sorting, it's value should be 0. |
| TargetColumn | String | This value specifies the name of the destination column in the data flow path mapping. |
Collection Children
| Child | API Type | Description |
|---|---|---|
| <Annotations> <Annotation /> </Annotations> | AstAnnotationNode | This is a collection of annotation items that can be used to specify documentation, tags, or other information. Annotations are particularly useful for storing information about nodes that can be used by BimlScript code. |
| <ComparisonFlags> <ComparisonFlag /> </ComparisonFlags> | ComparisonFlags | This value specifies a collection of flags that determine specific behaviors of the Fuzzy Grouping Component when comparing column values. |