Batch File for Comparing CSV RRS feed

  • Question

  • Help Request:Hi  
    I have 3 Excel CSV Files
    FileAA.csv- Live plant 
    FileBB.csv - Simulation Plant 

    I would like to compare both AA  and BB files and save the differences in FileCC.csv

    I would like to execute this from a BATCH File an operator will execute from the desktop..

    I have played with this script but it does not seem to do what I want it to do nor does it populate FileCC.csv

    $file1 = import-csv -Path "E:\FileAA.csv"           
    $file2 = import-csv -Path "E:\FileBB.csv"  

    Compare-Object $file1 $file2 -property col1,col2 -IncludeNotEqual

    Hope you can point me in the right direction
    • Edited by Bob Stokoe Wednesday, July 12, 2017 5:57 AM
    • Moved by Bill_Stewart Friday, March 9, 2018 7:18 PM This is not "scripts on demand"
    Wednesday, July 12, 2017 5:49 AM

All replies