The Challenge: I need to map the N2 1.0 to the main address field when the N3 1.0 does not exist. Since the N3 happens after the N2 the mapper won't let me condition the N2 off from the N3. Another challenge is sometimes, both the N2 and N3 segments are filled and should be mapped to the additional info address and main address fields respectively.

The Solution: The general strategy of the solution is to populate the main address with N2 and N3 as well. And additional info with N2 only. We will be putting these in work fields and only map these work fields to the user fields when N4 is reached.

1) When only N2 is existing, both the "additional info" and "main address" work fields will contain N2 1.0. That is why, we need to *blank the "additional info" work field when this happens.

2) When only N3 is existing, the "additional info" work field will be *BLANKS and "main address" work field will contain N3 1.0.

3) When both N2 and N3 are existing, the "additional info" work field will contain N2 1.0 and "main address" work field will contain N3 1.0.

Do you have a new CHALLENGE? Let us know HERE.