ImpMapSmall Your First Mapping

Merging Source Fields

Introduction  Previous Topic  Next Topic

There may be times when a specific destination field requires the merging of distinct source fields. The one-to-many mapping of EXAMPLE_SOURCE.TXT to Form 1099-MISC, created in the previous topic, clearly illustrates this. The problem with this mapping is that each recipient's "Middle" and "Last Name" has not been mapped. A simple solution would be to map "Last Name" è "Name line 2", but this would result in the recipient's "First Name" and "Last Name" printing on two distinct lines of Form 1099-MISC. Moreover, the "Middle" name was never mapped. The solution to this problem lies within IMU's power to merge source fields.

 

Merging Source Fields

The following steps illustrate how to merge the "First Name", "Middle", and "Last Name" fields of EXAMPLE_SOURCE.TXT into a single field, which is then be mapped to "Name line 1".

 

1.Click on source field 3, "Last Name".
2.With the mouse button depressed, drag the "Last Name" up and drop it onto source field 2, "Middle".
3.Note that source field 3 has been merged with source field 2, which now reads "Middle Last Name".
4.Click on source field 2, "Middle Last Name".
5.With the mouse button depressed, drag the "Middle Last Name" up and drop it onto source field 1, "First Name".
6.Note that source field 2 has been merged with source field 1, which now reads "First Middle Last Name".
7.The "First Middle Last Name" field can now be mapped to "Name line 1".

 

If successful, destination field "Name line 1" should now read "First Middle Last Name", the results of the merge.

 

note Notes

 

Merging the same source fields twice will undo the merge.
When merging exactly two source fields, the order of the fields relative to each other isn't important.
When merging more than two source fields, the order of the fields relative to each other is essential. That is, in order to successfully merge source fields I, J, K, ..., it must be true that source field I precedes source field J, source field J precedes source field K, ..., and so on.