Monday, December 28, 2020

Merge CSV files by using PowerShell

 

Compare two CSV files via PowerShell to find out difference and export results into new CSV file.

If you are looking for simple script can read two CSV file, which each CSV file has multiple columns, then compare them to find out the difference this script is just going to do that. Simply download and adjust few variables to make it work for your scenario.

I have added both CSV file content into script for you to see what script is pulling then variables you can change to make it fit into your needs.

Adjust your CSV file, if your columns are different, you have more columns etc. that is fine, just adjust them accordingly.

“Computername, and UserName “ are column name on the example below, thus script reflect both variables, and also PS custom object, just adjust them.

 

<#

 

#$File1

 

ComputerName UserName

------------ --------

XLT-001      Allison1

XLT-002      Allison2

XLT-003      Allison3

XLT-004      Allison4

XLT-005      Allison5

XLT-006      Allison6

XLT-007      Allison7

XLT-008      Allison8

XLT-009      Allison9

XLT-010      Allison10

WRK-010      Clint

 

#$File2

ComputerName UserName

------------ --------

XLT-001      Allison1

XLT-002      Allison2

XLT-003      Allison3

XLT-004      Allison4

XLT-005      Allison5

XLT-006      Allison6

XLT-007      Allison7

WRK-001      RAMBO   

XLT-008      Allison8

XLT-009      Allison9

XLT-010      Allison10

 

 

#>

 

 

 

#(1)_.Path for CSV Files that needs to be comppared

$CSV1 = "C:\Users\12024\OneDrive - wiretecpro\Desktop\Compare-CSV\Excell\File1.csv"

$CSV2 = "C:\Users\12024\OneDrive - wiretecpro\Desktop\Compare-CSV\Excell\File2.csv"

 

 

 

#(2)_.Path for export results to CSV

$CSV3 = "C:\Users\12024\OneDrive - wiretecpro\Desktop\Compare-CSV\Excell\DIFFERENCE.csv"

 

 

 

#(3)_.Import both CSV Files you would like to compare

$File1 = Import-Csv $CSV1

$File2 = Import-Csv $CSV2

 

 

#(4)_.Compare both CSV files - column ComputerName,UserName

 

$Results = Compare-Object  $File1 $File2 -Property ComputerName,UserName -IncludeEqual

 

 #(5)_.Set Array

$Array = @()

 

#(6)_.Loop Starts     

Foreach($item in $Results)

{

    If( $item.sideindicator -notcontains "==" )

    {

        $Object = [pscustomobject][ordered] @{

            ComputerName      = $item.ComputerName

            UserName          = $item.UserName

            Compare_Indicator = $item.sideindicator

 

        }

        $Array += $Object

    }

}

 

#(7)_.Count users in both files

($Array | sort-object ComputerName | Select-Object * -Unique).count

 

#(8)_.Display results in console

$Array

 

#(9)_.Export results into CSV File

$Array | export-csv -Path $CSV3 -NoTypeInformation

 

 

Casey, Dedeal

Principal Systems Engineer

https://simplepowershell.blogspot.com/  (blog)

https://smtp25.blogspot.com/ (blog)

https://telnet25.wordpress.com/ (blog)

https://twitter.com/Message_Talk (Twitter)

No comments:

Post a Comment

Setting up ISE Profile with Options

  Here is updated ISE profile. You can use it to built your own and make few adjustments.       # STARTING ADDS-ON MENU # ...