topic Combine two columns into one in Python Questions

Combine two columns into one

BartłomiejStaroń — Thu, 17 Mar 2011 13:56:58 GMT

I want to create a script that will combine two columns into one.
Unfortunately, I have a problem with the??? "None" value.
I don't know how to verify the other value from 2 column.
I have something like this:

cursor = gp.UpdateCursor("FC")
row = cursor.Next()
while row:
      if ( row.field == None):
       pass
      else:
       row.fieldoutput = row.field + row.field2
       cursor.UpdateRow(row)
      row = cursor.Next()

What should I do?

Re: Combine two columns into one

ChrisMathers — Thu, 17 Mar 2011 14:26:59 GMT

Have you tried

if row.field == None or row.field2 == None:
pass

That way if either has a None type value it would pass.

Re: Combine two columns into one

TylerGarner — Thu, 17 Mar 2011 17:04:24 GMT

Below is the code I would use to achieve this:

cursor=arcpy.UpdateCursor("FC")
for row in cursor:
[indent]if row.field:[/indent]
[indent][indent]row.fieldoutput=row.field+row.field2
cursor.UpdateRow(row)[/INDENT][/indent]

Re: Combine two columns into one

JasonScheirer — Thu, 17 Mar 2011 18:32:41 GMT

Try this:

row.fieldoutput=(row.field or '')+(row.field2 or '')

Re: Combine two columns into one

BartłomiejStaroń — Fri, 18 Mar 2011 12:35:47 GMT

I do somthing like tis and this is work

row.fieldautput = str(row.field1) + str(row.field2)

but when I am doing this empty field fill with values �??�??"None"