0

I joined two tables to a shapefile and the output table has a field from each. Both fields represent the same thing so I'd like to combine them into one. You can see a clip of my fields below, where most of nulls are populated in the adjacent field.

enter image description here

Simply enough, I just want the final output to read as (based on the fields above)

<null>
Complete
Verified 
Verified
Verified
Verified
Construction
Construction
Construction
<null>
Verified
Approved
Complete
Verified
<null>
Complete
etc

I was thinking about using field calculator to say "If field 1 is None, field 1 = field 2" but that either doesn't work or I was getting the syntax wrong. Also, I have a few sets of three fields that I need to merge so that wouldn't work for that unless I calculated twice?

1

in your field calculator, click the "show codeblock" button and enter this:

dim n
if isnull([columnone]) then
n = [columntwo]
else n = [columnone]
end if

and in the bottom field enter

n
  • Works like a charm, thanks! Should be easy enough to duplicate this a few times in my model for each field I need to merge! – Shaleby Feb 27 at 16:06

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.