Compare two CSV files with different column numbers on basis of a common column : <p>Using powershell for the first time.
I have 2 csv files. Each have different number of columns, and have different number of entries and not in same sequence.</p>

<p>Here are some examples of the first couple lines</p>

<blockquote>
  <p>File1.csv</p>
</blockquote>

<pre><code>    Name,Alias,Category
    Comdty,CONTRACT FOR DIFFERENCE,Future
    Comdty,Calendar Spread Option,Future
    Corp,Bond,FixedIncome
    Corp,EURO-DOLLAR,FixedIncome
    Corp,FLOORSPREAD,FixedIncome
    Corp,FRA,FixedIncome
</code></pre>

<blockquote>
  <p>File2.CSV</p>
</blockquote>

<pre><code>Alias,Category
EURO-DOLLAR,FixedIncome
Bond,FixedIncome
Preferred,Equity
</code></pre>

<p>I need to compare the files using PowerShell script on the basis of Alias column,and show the matching values together and showing blank where the value not exist for either file.
Something like :</p>

<pre><code>   Alias,Alias, Category ------------------------- MacthCase
   ___,CONTRACT FOR DIFFERENCE,Future ------------ false
   ___,Calendar Spread Option,Future ------------- false
   Bond,Bond,FixedIncome ------------------------- true
   EURO-DOLLAR,EURO-DOLLAR,FixedIncome ----------- true
   ___,FLOORSPREAD,FixedIncome ------------------- false
   ___,FRA,FixedIncome --------------------------- false
   Preferred,___,Equity -------------------------- false
</code></pre>
