title: Inner Join in PowerShell (without SQL)
body: <p>How do we make <code>Inner-Join</code> or something a <code>Cross-Join</code> in PowerShell or PowerCLI?</p>
  
  <p>Even though im new to PowerCLI/PowerShell , I do have a basic grasp on them, yet have practically spent 2 days trying to figure this, going through numerous documentations and blogs to no avail.</p>
  
  <p>All I really want to know is if after typing my command</p>
  
  <pre><code>Get-Content File.txt 
  </code></pre>
  
  <p>and getting:</p>
  
  <pre>Output1 or Table1 is
  
  Name: Abc
  Group: Bad
  Policy: Great
  
  Name: redi
  Group: Good 
  Policy: MAD
  
  etc. etc.</pre>
  
  <p>100s of these, and obviously more than just the 3 elements of Name, Group, Policy each.</p>
  
  <hr>
  
  <pre>Table2/Output2
  
  Name: Abc
  Limit: 10
  used: 5
  
  Name: redi
  Limit: 20
  used: 1
  
  etc. etc.</pre>
  
  <p>100s of these.</p>
  
  <hr>
  
  <p>and like 13 more of these text file tables, all with the "Name" as unique.</p>
  
  <p>How can I combine it into one output at the end using Name with all the other elements?</p>
  
  <p>My most obvious thought was something akin to joins, even if I had to do them 1 at a time, but even that I cant figure out how to do.</p>
  
  <p>Is there anyway to do this in PowerShell itself without me having to go into Python or SQL?</p>
  
  <p>If yes is there a method that is able to combine fields in spots where it's null?</p>
  
  <p>If its not clear what type of result I am hoping for it will look something akin to this:</p>
  
  <pre>Name: Abc
  Group: Bad
  Policy: Great
  Limit: 10
  used: 5
  
  
  Name: redi
  Group: Good 
  Policy: MAD
  Limit: 20
  used: 1</pre>