I am not sure what is wrong with the script. I have a 3 column csv file that consists of Name,Count,Owner. The goal is to get the highest count of each name, then output all 3 columns, however the Owner column is not outputting. I am only getting Name, Total. I would appreciate if someone would assist in showing me what is wrong, many thanks.
$total = Import-Csv -Delimiter ',' -Path "file.csv"
$total = $total | Group-object -Property Name | Select Name, @{ N = 'Total';E = {($_.Group | Measure-Object -Property count -Maximum).Maximum }},Owner
Contents of csv file:
"Name","Count","Owner"
"ctx_Prd-DG","1","User1"
"PRD-Fa","5","User2"
"ING-PROD","3","User2"
"PROD-DG03","0","User2"
"PROD-DG01","0","User2"
"PRD-2018-DG","1","User3"
"PRD-7-DG","5","User3"
"PRD-7-DG-PR15","0","User3"
"PRD-CS-DG","0","User3"
"PRD-INSIGHT-DG","0","User3"
"PRD-LIVE-DG","0","User3"
"DC01-DG","0","User4"
"Test - DG","0","User4"
"PRD-CS-DG","0","User3"
"INSIGHT-DG","0","User3"
"ctx_Prd-DG","1","User1"
"PRD-Fa","1","User2"
"ING-PROD","0","User2"
"PROD-DG03","0","User2"
"PROD-DG01","0","User2"
"PRD-2018-DG","7","User3"
"PRD-7-DG","5","User3"
"PRD-7-DG-PR15","0","User3"
"PRD-CS-DG","0","User3"
"PRD-INSIGHT-DG","0","User3"
"PRD-LIVE-DG","2","User3"
"DC01-DG","1","User4"
"Test - DG","8","User4"
"PRD-CS-DG","20","User3"
"INSIGHT-DG","0","User3"
Simply $total | Group-Object -Property Name does not have a property "Owner"
# `Get-Member -MemberType Properties` shows properties of an object.
$group = $total | Group-Object -Property Name
$group | Get-Member -MemberType Properties
# See how `Group-Object` groups each item,
$group[1].Group
$group[2].Group
So your code will be like the following
$csv = Import-Csv "file.csv"
$total = $csv | Group-Object -Property Name | Select Name, @{
N = 'Total'
E = { ($_.Group | Measure-Object -Property count -Maximum).Maximum }
}, @{
N = 'Owner'
E = { $_.Group.Owner[0] }
}