title: Comparing DataTable cells from two DataTables
body: <p>I've been working on a project that will use NLP to define DataTable values. I've already gotten that function up. However, I've ran into some issues when working with DataTables.</p>
  
  <p>I will have two different DataTables, both of different formats </p>
  
  <p>e.g.:</p>
  
  <p><strong>TABLE1</strong></p>
  
  <p>|Column 1|</p>
  
  <p><strong>TABLE2</strong></p>
  
  <p>|Column 1|Column 2|</p>
  
  <p>In DataTable2, Column 2 is a corresponding value to Column 1.
  I intend to compare the cell contents of both DataTables' Column 1s, and run it through my NLP. If they have a certain matching percentage, I will write them to another DataTable. If they fail to match, I'll just leave it blank.
  So for example:</p>
  
  <p><strong>If >75% match</strong></p>
  
  <p><strong>TABLE3</strong></p>
  
  <p>|DT1 Col 1| DT2 Col 1 | DT2 Col 2|</p>
  
  <p><strong>If &lt;75% match</strong></p>
  
  <p><strong>TABLE3</strong></p>
  
  <p>|DT1 Col 1| " " | " "</p>
  
  <p>Is what I'm aiming to do programatically possible? I've pseudo code in mind if it helps explain it better.</p>
  
  <pre><code>foreach(DataRow in Table1)
     foreach(DataRow in Table2)
        if(comparison score &gt;=75.00)
              Write to table3
        else
              Write to table3 with blanks
  </code></pre>
  
  <p>I'd appreciate any help on this problem. I'll still be doing my own research though, and I'll post back if I make any breakthroughs. </p>
  
  <p>EDIT:
  I've just realized the rows in the two DataTables might not necessarily correspond, so I'll have to run the comparison against all cells. Is that possible?</p>
  
  <p>It doesn't necessarily have to be working with DataTables though, I'm open to suggestions. </p>