Compare-Object show mathmatical difference

This topic contains 1 reply, has 2 voices, and was last updated by  Olaf Soyk 3 months, 2 weeks ago.

  • Author
    Posts
  • #98154

    chad volz
    Participant

    Trying to compare two excel sheets, select out a specific column and then compare the values in each row and return the difference.

    I removed the side indicators cause it was throwing off my format in the post.

    $Diff = import-csv C:\scripts\Testing_diff.csv | Select-Object Name, Volume
    $reff = import-csv C:\scripts\Testing_reff.csv | Select-Object Name, Volume
    Compare-Object $reff $Diff -Property Name, Volume -PassThru -IncludeEqual
    

    and it just spits back the following, Trying to get it to give me back the difference of the volume data.

    Name                  Volume   SideIndicator
    ----                  ------   -------------
    Development_b_001     1549.50G           
    Production_b_001      11.57T              
    Production_b_002      1600.03G            
    Development_b_001     549.50G            
    Production_b_001      1.57T              
    Production_b_002      600.03G 
    
  • #98158

    Olaf Soyk
    Participant

    Compare-Object will not calculate for you. It compares objects or object properties and tell if it's equal or not. If you need to calculate a difference you will have to do it by yourself.

You must be logged in to reply to this topic.