I have power lines for a utility that I want to merge into our esri gis system. For any given feature class there are some field that will map straight across without modification. But there are many cases (many fields) where they have, what I think of as an esri domain (a code - integer linked to a description- string). Then on our side, we have a normal arcgis domain. So, for example, they may have an attribute value of 2 that I need to change to a 4 when it is loaded into our gis. At first, I used the attribute value mapper. This worked great. But it does not appear to work well for many fields. So, now I am trying to do it with schema mapper. I did the tutorials but still having a hard time getting it to work.

So, questions are:

1) Is schema right tool for this problem?

2) If so... what is wrong with my workflow:

Lookup table test (only one field so far)

Actions

What I am trying to say is:

if ID_PHASE = 1 then PHASEDESIGNATION = 99

Thanks for the help!