title: Update information to my column in awk
body: <p>I have two files - in each file is two column and many rows.. I need to update information from second file and overwrite it in first file.</p>
  
  <p>For example:</p>
  
  <p>File1:       File2</p>
  
  <pre><code>A 1       B 7
  B 2       C 8
  C 3       D 9
  D 4       E 10 
  E 5       H 1
  F 6       I 7 
  G 7
  </code></pre>
  
  <p>And I need to add new values from second file and update existing values:</p>
  
  <p>Final_file:</p>
  
  <pre><code>A 1
  B 7
  C 8
  D 9
  E 10
  F 6
  G 7
  H 1
  I 7  
  </code></pre>
  
  <p>I hope my question is clear. Important is, that both file doesnt have the same number of rows and rows are not matching. </p>
  
  <p>I was try something like this :</p>
  
  <pre><code>awk 'NR==FNR { a[$1]=$2; next} $1 in a {print $0, a[$1]}' File1 File2 
  </code></pre>
  
  <p>but ouput are just matching columns:</p>
  
  <pre><code>B 2 7
  C 3 8
  D 4 9
  E 5 10
  </code></pre>
  
  <p>Can anybody please help fix my code to keep all informations update!!</p>
  
  <p>Thank you so much for nay help!</p>