topic In Field Calculator 1 To 9 Loop Numbers in Data Management Questions https://community.esri.com/t5/data-management-questions/in-field-calculator-1-to-9-loop-numbers/m-p/633493#M35803 <HTML><HEAD></HEAD><BODY><P>I have a field name gfdd i want to fill &nbsp;A&nbsp;to I&nbsp;in loop till end.&nbsp;</P><P></P><P>Like This</P><P>A&nbsp;B&nbsp;C&nbsp;D&nbsp;E&nbsp;F&nbsp;G&nbsp;H&nbsp;I <SPAN>A</SPAN><SPAN>&nbsp;</SPAN><SPAN>B</SPAN><SPAN>&nbsp;</SPAN><SPAN>C</SPAN><SPAN>&nbsp;</SPAN><SPAN>D</SPAN><SPAN>&nbsp;</SPAN><SPAN>E</SPAN><SPAN>&nbsp;</SPAN><SPAN>F</SPAN><SPAN>&nbsp;</SPAN><SPAN>G</SPAN><SPAN>&nbsp;</SPAN><SPAN>H</SPAN><SPAN>&nbsp;</SPAN><SPAN>I&nbsp;A<SPAN>&nbsp;</SPAN><SPAN>B</SPAN><SPAN>&nbsp;</SPAN><SPAN>C</SPAN><SPAN>&nbsp;</SPAN><SPAN>D</SPAN><SPAN>&nbsp;</SPAN><SPAN>E</SPAN><SPAN>&nbsp;</SPAN><SPAN>F</SPAN><SPAN>&nbsp;</SPAN><SPAN>G</SPAN><SPAN>&nbsp;</SPAN><SPAN>H</SPAN><SPAN>&nbsp;</SPAN><SPAN>I&nbsp;A<SPAN>&nbsp;</SPAN><SPAN>B</SPAN><SPAN>&nbsp;</SPAN><SPAN>C</SPAN><SPAN>&nbsp;</SPAN><SPAN>D</SPAN><SPAN>&nbsp;</SPAN><SPAN>E</SPAN><SPAN>&nbsp;</SPAN><SPAN>F</SPAN><SPAN>&nbsp;</SPAN><SPAN>G</SPAN><SPAN>&nbsp;</SPAN><SPAN>H</SPAN><SPAN>&nbsp;</SPAN><SPAN>I....................................................</SPAN></SPAN></SPAN></P><P></P><P>And then i want to combine Map_ to gfdd in different field&nbsp;:</P><P>Like This :</P><P></P><P>Map_ &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;gfdd &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Test</P><P>46K1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;A &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<SPAN>46K1 A</SPAN></P><P><SPAN>46K1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;B &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;46K1 B</SPAN></P><P><SPAN>46K1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;C&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 46K1 C</SPAN></P><P><SPAN>46K1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;D&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 46K1 D</SPAN></P><P><SPAN>46K1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;E&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;46K1 E</SPAN></P><P><SPAN>46K1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;F&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;46K1 F</SPAN></P><P><SPAN>46K1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;G &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;46K1 G</SPAN></P><P><SPAN>46K1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;H &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;46K1 H</SPAN></P><P><SPAN>46K1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; I&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;46K1 I</SPAN></P><P><SPAN>46O1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<SPAN>A</SPAN><SPAN> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;</SPAN><SPAN>46O1 A</SPAN></SPAN></P><P><STRONG><SPAN style="font-weight: normal;">46O1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;</SPAN><SPAN style="font-weight: normal;">B</SPAN><SPAN style="font-weight: normal;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</SPAN><SPAN style="font-weight: normal;">46O1&nbsp;B</SPAN></STRONG></P><P><STRONG style="font-weight: normal;">&nbsp;</STRONG></P></BODY></HTML> Tue, 31 Jan 2017 19:16:37 GMT NeeleshSonekar 2017-01-31T19:16:37Z In Field Calculator 1 To 9 Loop Numbers https://community.esri.com/t5/data-management-questions/in-field-calculator-1-to-9-loop-numbers/m-p/633493#M35803 <HTML><HEAD></HEAD><BODY><P>I have a field name gfdd i want to fill &nbsp;A&nbsp;to I&nbsp;in loop till end.&nbsp;</P><P></P><P>Like This</P><P>A&nbsp;B&nbsp;C&nbsp;D&nbsp;E&nbsp;F&nbsp;G&nbsp;H&nbsp;I <SPAN>A</SPAN><SPAN>&nbsp;</SPAN><SPAN>B</SPAN><SPAN>&nbsp;</SPAN><SPAN>C</SPAN><SPAN>&nbsp;</SPAN><SPAN>D</SPAN><SPAN>&nbsp;</SPAN><SPAN>E</SPAN><SPAN>&nbsp;</SPAN><SPAN>F</SPAN><SPAN>&nbsp;</SPAN><SPAN>G</SPAN><SPAN>&nbsp;</SPAN><SPAN>H</SPAN><SPAN>&nbsp;</SPAN><SPAN>I&nbsp;A<SPAN>&nbsp;</SPAN><SPAN>B</SPAN><SPAN>&nbsp;</SPAN><SPAN>C</SPAN><SPAN>&nbsp;</SPAN><SPAN>D</SPAN><SPAN>&nbsp;</SPAN><SPAN>E</SPAN><SPAN>&nbsp;</SPAN><SPAN>F</SPAN><SPAN>&nbsp;</SPAN><SPAN>G</SPAN><SPAN>&nbsp;</SPAN><SPAN>H</SPAN><SPAN>&nbsp;</SPAN><SPAN>I&nbsp;A<SPAN>&nbsp;</SPAN><SPAN>B</SPAN><SPAN>&nbsp;</SPAN><SPAN>C</SPAN><SPAN>&nbsp;</SPAN><SPAN>D</SPAN><SPAN>&nbsp;</SPAN><SPAN>E</SPAN><SPAN>&nbsp;</SPAN><SPAN>F</SPAN><SPAN>&nbsp;</SPAN><SPAN>G</SPAN><SPAN>&nbsp;</SPAN><SPAN>H</SPAN><SPAN>&nbsp;</SPAN><SPAN>I....................................................</SPAN></SPAN></SPAN></P><P></P><P>And then i want to combine Map_ to gfdd in different field&nbsp;:</P><P>Like This :</P><P></P><P>Map_ &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;gfdd &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Test</P><P>46K1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;A &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<SPAN>46K1 A</SPAN></P><P><SPAN>46K1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;B &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;46K1 B</SPAN></P><P><SPAN>46K1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;C&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 46K1 C</SPAN></P><P><SPAN>46K1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;D&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 46K1 D</SPAN></P><P><SPAN>46K1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;E&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;46K1 E</SPAN></P><P><SPAN>46K1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;F&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;46K1 F</SPAN></P><P><SPAN>46K1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;G &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;46K1 G</SPAN></P><P><SPAN>46K1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;H &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;46K1 H</SPAN></P><P><SPAN>46K1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; I&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;46K1 I</SPAN></P><P><SPAN>46O1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<SPAN>A</SPAN><SPAN> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;</SPAN><SPAN>46O1 A</SPAN></SPAN></P><P><STRONG><SPAN style="font-weight: normal;">46O1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;</SPAN><SPAN style="font-weight: normal;">B</SPAN><SPAN style="font-weight: normal;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</SPAN><SPAN style="font-weight: normal;">46O1&nbsp;B</SPAN></STRONG></P><P><STRONG style="font-weight: normal;">&nbsp;</STRONG></P></BODY></HTML> Tue, 31 Jan 2017 19:16:37 GMT https://community.esri.com/t5/data-management-questions/in-field-calculator-1-to-9-loop-numbers/m-p/633493#M35803 NeeleshSonekar 2017-01-31T19:16:37Z Re: In Field Calculator 1 To 9 Loop Numbers https://community.esri.com/t5/data-management-questions/in-field-calculator-1-to-9-loop-numbers/m-p/633494#M35804 <HTML><HEAD></HEAD><BODY><P>Combining the two fields, once you have them, if fairly straightforward.&nbsp; For generating the <SPAN style="font-family: courier new,courier,monospace;">gfdd</SPAN> field, the following should work using the Python parser:</P><P>Pre-Logic Script Code:</P><PRE class="lia-code-sample line-numbers language-none"><CODE><SPAN class="keyword token">from</SPAN> itertools <SPAN class="keyword token">import</SPAN> cycle rot <SPAN class="operator token">=</SPAN> cycle<SPAN class="punctuation token">(</SPAN>chr<SPAN class="punctuation token">(</SPAN>i<SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">for</SPAN> i <SPAN class="keyword token">in</SPAN> range<SPAN class="punctuation token">(</SPAN><SPAN class="number token">65</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="number token">74</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">def</SPAN> <SPAN class="token function">next_letter</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN> &nbsp;&nbsp;&nbsp; <SPAN class="keyword token">return</SPAN> next<SPAN class="punctuation token">(</SPAN>rot<SPAN class="punctuation token">)</SPAN>‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><P>Value:</P><P><SPAN style="font-family: courier new,courier,monospace;">next_letter()</SPAN></P></BODY></HTML> Sun, 12 Dec 2021 02:57:03 GMT https://community.esri.com/t5/data-management-questions/in-field-calculator-1-to-9-loop-numbers/m-p/633494#M35804 JoshuaBixby 2021-12-12T02:57:03Z Re: In Field Calculator 1 To 9 Loop Numbers https://community.esri.com/t5/data-management-questions/in-field-calculator-1-to-9-loop-numbers/m-p/633495#M35805 <HTML><HEAD></HEAD><BODY><P>Thank you Very Much............Very Helpful&nbsp;For Me.................</P></BODY></HTML> Wed, 01 Feb 2017 07:42:15 GMT https://community.esri.com/t5/data-management-questions/in-field-calculator-1-to-9-loop-numbers/m-p/633495#M35805 NeeleshSonekar 2017-02-01T07:42:15Z