Append values to Powershell object

Question

I have a PS object and couldnt figure out a way to append values to my object.

$object = New-Object PSObject
Add-Member -InputObject $object -MemberType NoteProperty -Name Col1 -Value ""
Add-Member -InputObject $object -MemberType NoteProperty -Name Col2 -Value ""
Add-Member -InputObject $object -MemberType NoteProperty -Name Type -Value ""
1..10 |ForEach{
    $src=$_
    11..20 | ForEach{
        $dst = $_
        $object.Col1=$src
        $object.Col2=$dst
        $object.Type="New"
    }    
}

I want my result like

col1  col2  Type
----  ----  ----
   1    11  New
   1    12  New
   1    13  New
   1    14  New
...

Burt_Harris · Accepted Answer · 2016-09-15 22:42:35Z

2

Use a PSCustomObject:

$values = 1..10 | % { 
   [pscustomobject]@{ col1=1; col2=10+$_; Type="New" }
   }

edited Sep 15, 2016 at 22:42

answered Sep 15, 2016 at 21:22

Burt_Harris

6,9522 gold badges35 silver badges70 bronze badges

Sign up to request clarification or add additional context in comments.

10 Comments

user1550159 Over a year ago

Thanks, how do i save that to an object and use it some where in my script.I tired saving it an object, but it saved only last element.

Ansgar Wiechers Over a year ago

PSOjbect or PSCustomObject doesn't make a difference (unless you want to use a type accelerator). The point is to create (and output) new objects inside the loop. The list can be captured by assigning the pipeline output to a variable: $list = 1..10 | % {...}

Burt_Harris Over a year ago

I've updated the example to save into variable $values. I get different results @AnsgarWiechers, try it yourself replacing pscustomobject with psobject.

Ansgar Wiechers Over a year ago

You're using a type accelerator, so yes, you're getting different results. Use New-Object and the results will be the same.

Burt_Harris Over a year ago

@AnsgarWiechers, yes but try this: New-Object -Type PSObject | GM. It returns a PSCustomObject even though you ask for a PSObject. Special cases abound in this area.

|

Community · Accepted Answer · 2017-05-23 12:00:55Z

The output you want is a list of objects, not a single object. You generate that by creating the objects inside the loop. @Burt_Harris already showed you one way to do that (using a type accelerator [PSCustomObject]), but of course you can also use New-Object to the same end:

$list = 1..10 | ForEach-Object {
    $src = $_
    11..20 | ForEach-Object {
        $prop = @{
            Col1 = $src
            Col2 = $_
            Type = 'New'
        }
        New-Object -Type PSObject -Property $prop
    }
}

Create the property hashtable as an ordered hashtable if you want the properties to appear in a particular order in the output (PowerShell v3 and newer only):

$prop = [ordered]@{
    Col1 = $src
    Col2 = $_
    Type = 'New'
}

The list of objects can be captured by assigning the pipeline output to a variable ($list = ...).

Collectives™ on Stack Overflow

Append values to Powershell object

2 Answers 2

10 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

10 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related