0 
topic,counter,details1,details2

books,3,green,red
books,5,green,yellow
books,1,green,red
books,2,green,red
books,8,blue,grey
house,1,green,green
house,2,red,red
house,5,green,green

If columns 1, 3, 4 of a line are equal and there are duplicated in list then they should consolidated.

So results should look like. So line 3,4,8 are eliminated and the counters for line 1 and 6 increment.

books,6,green,red
books,5,green,yellow
books,8,blue,grey
house,6,green,green
house,2,red,red

Any idea how to realize this in PowerShell?

Improve this question
2
  • 1
    Have you tried anything? Commented Dec 6, 2021 at 11:21
  • yes nested for loop but thought it must be easier Commented Dec 6, 2021 at 13:22

1 Answer 1

Reset to default
2

Use the Group-Object cmdlet to group objects by common property values, then sum the counter property from each object within each group:

Import-Csv ./path/to/file.csv |Group-Object topic,details1,details2 |ForEach-Object {
    # for each group of distinct objects, create 1 new object where the `counter` value is the sum of all values in the group
    [pscustomobject]@{
        topic = $_.Group[0].topic
        topic = ($_.Group |Measure-Object counter -Sum).Sum
        details1 = $_.Group[0].details1
        details2 = $_.Group[0].details2
    }
} |Export-Csv ./path/to/output.csv -NoTypeInformation
Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.