title: Trying to properly set up query for match of 2 csv files got stuck
body: <p>Here's an example of what the data looks like on each csv.</p>
  <p><strong>inventory.csv</strong></p>
  <pre><code>ID, payment, Receipt#                                 
  90006, VISA, jk73kl_                          
  90006, VISA, null                             
  </code></pre>
  <p><strong>inventory.csv</strong></p>
  <pre><code>INFO, VIEWS, DATE
  9006_Produce_Banana_jk73kl__, 0, 10-13-20
  9006_Produce_Banana, 0, 10-13-20 
  </code></pre>
  <p>I am having trouble with my where, I need to search both forms and if there is a matching receipt number pull them out and combine the two rows.</p>
  <pre><code>using System;
  using System.Collections.Generic;
  using System.Linq;
  
  
  namespace ConsoleApp1
  {
      class Program
      {
          static void Main()
          {
              string[] ourDataSheet = System.IO.File.ReadAllLines(@&quot;../../OurData.csv&quot;);
              string[] theirDataSheet = System.IO.File.ReadAllLines(@&quot;../../TheirData.csv&quot;);
              string ourDataHeaders = ourDataSheet[0];
              string theirDataHeaders = theirDataSheet[0];
              
  
              IEnumerable&lt;string&gt; TrackingQuery =
                  from ourData in ourDataSheet
                  let ourDataFields = ourData.Split(',')
                  from theirData in theirDataSheet
                  let theirDataFields = theirData.Split(',')
                  where theirDataFields[0].EndsWith(ourDataFields[2])
                  select ourDataFields[0] + &quot;,&quot; + ourDataFields[1] + &quot;,&quot; + ourDataFields[2] + &quot;,&quot; + theirDataFields[0] + &quot;,&quot; + theirDataFields[0] + &quot;,&quot; + theirDataFields[1] + &quot;,&quot; + theirDataFields[2] + &quot;,&quot; + theirDataFields[3];
  
              OutPutResults(TrackingQuery);
  
              Console.ReadKey();
          }
  
          static void OutPutResults(IEnumerable&lt;string&gt; query)
          {
              foreach(string item in query)
              {
                 Console.WriteLine(item);
                 Console.Read();
                 
              }
          }
      }
  }
  </code></pre>