Target File Fields | Match By Name | Match By Position |
|---|---|---|
Target file has a single field. | The Expression column populates the appropriate field name (matching with the source name). | The Expression column populates the appropriate field name (matching with the source position). |
Target field name is edited manually. For example, change the expression for a field. | The expression field should display the changed value. The Expression column replaces the field name with the appropriate field name (matching with source). | |
Target field names are in random order. | The Expression column populates the appropriate field name (matching with source name). | The Expression column populates the appropriate field name (matching with source position). |
Target file has multiple field columns. | The Expression column populates all the appropriate field names (matching with source name) | The Expression column populates all the appropriate field names (matching with source position). |
Target fields are lesser than source fields. | The Expression column populates all the appropriate field names(matching with source name). | The Expression column populates all the appropriate field names (matching with source position). |
Target fields are more than source fields. | Mapping is done only for the fields that match the source field name. The fields that do not match remain unmapped. | Mapping is done only for the fields that match the source field position. The fields that do not match remain unmapped. |