Hi~~~ def Reclass(arg): if arg in ["222", "333"]: return " " else: return arg I want the results as shown below.

Do not return " " because it will not set a field to SQL NULL, it will set a field to a text string that says " ". If you want to set a field to SQL NULL, you want to return None.

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

python

KalSsin

Hi~~~

def Reclass(arg):
    if arg in ["222", "333"]:
        return "<Null>"
    else:
        return arg

I want the results as shown below.

Najděte více příspěvků označených jako

Accepted answers

bixb0012

Do not return "<NULL>" because it will not set a field to SQL NULL, it will set a field to a text string that says "<NULL>". If you want to set a field to SQL NULL, you want to return None.

All comments

KalSsin

Thank you

KalSsin

Thank you so much~~~~~~

#prelogic codeblock

def Reclass(arg1, arg2):
    if arg1 in ["222", "333"]:
        return None
    else:
        return arg2

#code

Reclass(!NAME!, !PNAME!)

bixb0012

Do not return "<NULL>" because it will not set a field to SQL NULL, it will set a field to a text string that says "<NULL>". If you want to set a field to SQL NULL, you want to return None.

DavidPike

Nearly there, but you need to pass in 2 arguments.

<SPAN class="comment token">#prelogic codeblock</SPAN>

<SPAN class="keyword token">def</SPAN> <SPAN class="token function">Reclass</SPAN><SPAN class="punctuation token">(</SPAN>arg1<SPAN class="punctuation token">,</SPAN> arg2<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
    <SPAN class="keyword token">if</SPAN> arg1 <SPAN class="keyword token">in</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">"222"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"333"</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">:</SPAN>
        <SPAN class="keyword token">return</SPAN> <SPAN class="string token">"<Null>"</SPAN>
    <SPAN class="keyword token">else</SPAN><SPAN class="punctuation token">:</SPAN>
        <SPAN class="keyword token">return</SPAN> arg2


<SPAN class="comment token">#code</SPAN>

Reclass<SPAN class="punctuation token">(</SPAN>!NAME!<SPAN class="punctuation token">,</SPAN> !PNAME!<SPAN class="punctuation token">)</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Připojte se k diskusi

Přihlášení členové mohou přispívat, sledovat aktualizace a další. Jste tu noví? Zaregistrujte si bezplatný účet.

Rychlé odkazy

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.