<div dir="ltr">I have the following attribute table with two fields ID and ID2<br><div><div><img src="cid:ii_kdz4sndd0" alt="image.png" width="414" height="418"><br></div></div><div><br></div><div>What expression can I use within the field calculator so that, I can fill the values for ID2 as below?</div><div><br></div><div><table border="0" cellpadding="0" cellspacing="0" width="146" style="border-collapse:collapse;width:110pt">
<colgroup><col width="64" style="width:48pt">
<col width="82" style="width:62pt">
</colgroup><tbody><tr height="20" style="height:15pt">
<td height="20" class="gmail-xl63" width="64" style="height:15pt;width:48pt;text-align:center;border:0.5pt solid windowtext;padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;white-space:nowrap">ID</td>
<td class="gmail-xl63" width="82" style="border-left:none;width:62pt;text-align:center;border-top:0.5pt solid windowtext;border-right:0.5pt solid windowtext;border-bottom:0.5pt solid windowtext;padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;white-space:nowrap">ID2</td>
</tr>
<tr height="20" style="height:15pt">
<td height="20" class="gmail-xl63" style="height:15pt;border-top:none;text-align:center;border-right:0.5pt solid windowtext;border-bottom:0.5pt solid windowtext;border-left:0.5pt solid windowtext;padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;white-space:nowrap">1</td>
<td class="gmail-xl63" style="border-top:none;border-left:none;text-align:center;border-right:0.5pt solid windowtext;border-bottom:0.5pt solid windowtext;padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;white-space:nowrap">Yellow</td>
</tr>
<tr height="20" style="height:15pt">
<td height="20" class="gmail-xl63" style="height:15pt;border-top:none;text-align:center;border-right:0.5pt solid windowtext;border-bottom:0.5pt solid windowtext;border-left:0.5pt solid windowtext;padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;white-space:nowrap">2</td>
<td class="gmail-xl63" style="border-top:none;border-left:none;text-align:center;border-right:0.5pt solid windowtext;border-bottom:0.5pt solid windowtext;padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;white-space:nowrap">Green </td>
</tr>
<tr height="20" style="height:15pt">
<td height="20" class="gmail-xl63" style="height:15pt;border-top:none;text-align:center;border-right:0.5pt solid windowtext;border-bottom:0.5pt solid windowtext;border-left:0.5pt solid windowtext;padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;white-space:nowrap">3</td>
<td class="gmail-xl63" style="border-top:none;border-left:none;text-align:center;border-right:0.5pt solid windowtext;border-bottom:0.5pt solid windowtext;padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;white-space:nowrap">White</td>
</tr>
<tr height="20" style="height:15pt">
<td height="20" class="gmail-xl63" style="height:15pt;border-top:none;text-align:center;border-right:0.5pt solid windowtext;border-bottom:0.5pt solid windowtext;border-left:0.5pt solid windowtext;padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;white-space:nowrap">4</td>
<td class="gmail-xl63" style="border-top:none;border-left:none;text-align:center;border-right:0.5pt solid windowtext;border-bottom:0.5pt solid windowtext;padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;white-space:nowrap">Blue</td>
</tr>
<tr height="20" style="height:15pt">
<td height="20" class="gmail-xl63" style="height:15pt;border-top:none;text-align:center;border-right:0.5pt solid windowtext;border-bottom:0.5pt solid windowtext;border-left:0.5pt solid windowtext;padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;white-space:nowrap">5</td>
<td class="gmail-xl63" style="border-top:none;border-left:none;text-align:center;border-right:0.5pt solid windowtext;border-bottom:0.5pt solid windowtext;padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;white-space:nowrap">Orange</td>
</tr>
<tr height="20" style="height:15pt">
<td height="20" class="gmail-xl63" style="height:15pt;border-top:none;text-align:center;border-right:0.5pt solid windowtext;border-bottom:0.5pt solid windowtext;border-left:0.5pt solid windowtext;padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;white-space:nowrap">6</td>
<td class="gmail-xl63" style="border-top:none;border-left:none;text-align:center;border-right:0.5pt solid windowtext;border-bottom:0.5pt solid windowtext;padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;white-space:nowrap">Brown</td>
</tr>
<tr height="20" style="height:15pt">
<td height="20" class="gmail-xl63" style="height:15pt;border-top:none;text-align:center;border-right:0.5pt solid windowtext;border-bottom:0.5pt solid windowtext;border-left:0.5pt solid windowtext;padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;white-space:nowrap">7</td>
<td class="gmail-xl63" style="border-top:none;border-left:none;text-align:center;border-right:0.5pt solid windowtext;border-bottom:0.5pt solid windowtext;padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;white-space:nowrap">Light Blue</td>
</tr>
<tr height="20" style="height:15pt">
<td height="20" class="gmail-xl63" style="height:15pt;border-top:none;text-align:center;border-right:0.5pt solid windowtext;border-bottom:0.5pt solid windowtext;border-left:0.5pt solid windowtext;padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;white-space:nowrap">8</td>
<td class="gmail-xl63" style="border-top:none;border-left:none;text-align:center;border-right:0.5pt solid windowtext;border-bottom:0.5pt solid windowtext;padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;white-space:nowrap">Light Yellow</td>
</tr>
<tr height="20" style="height:15pt">
<td height="20" class="gmail-xl63" style="height:15pt;border-top:none;text-align:center;border-right:0.5pt solid windowtext;border-bottom:0.5pt solid windowtext;border-left:0.5pt solid windowtext;padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;white-space:nowrap">9</td>
<td class="gmail-xl63" style="border-top:none;border-left:none;text-align:center;border-right:0.5pt solid windowtext;border-bottom:0.5pt solid windowtext;padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;white-space:nowrap">Light Green</td>
</tr>
</tbody></table></div><div><br></div><div><br></div><div><br></div></div>