Export-Csv variable object data

Hi, I'm trying to export an object in PowerShell into a CSV file. My goal is to include all properties in the CSV file ,but find that only properties from the first object are included. For e...

Windows PowerShell

farismalaeb

Steel Contributor

Feb 08, 2021

Haniel Croitoru

Hi,

Would you please add a bit of code to understand exactly, maybe my bad English did not help me this time.

Are the First Object and the Second object are independent objects or related to the same PSObject

$PS1stobject=@{
Name="First Object"
id = "1"
}
$PS2ndobject=@{
Name="Second Object"
id = "2"
Value="123"
}

$PSFirstObject=New-Object -TypeName PSObject -Property $PS1stobject
$PsSecondObject=New-Object -TypeName PSObject -Property $PS2ndobject

And what you want to do is export the content of both PSObject to the same CSV ?

Thanks

Haniel Croitoru

Learn Expert

Feb 10, 2021

farismalaeb

I actually needed to create a new object, iterate through all existing objects and add all members into the new object and then keep only the unique values. Then I added this object into a new collection and all other objects after it.

# Create superset of fields
$memberColl = @()
$total = $objCollection.count
$i = 1
foreach ($obj in $objCollection)
{
    Write-Progress -Activity "Consolidating properties" -Status $obj.id -PercentComplete ($i*100/$total)
    $members = (Get-Member -InputObject $obj -MemberType NoteProperty | select Name)
    foreach ($m in $members)
    {
        $memberColl += $m.Name
    }
    $i++
}

# create a list of all properties
$Properties = ($memberColl | sort | Select-Object -Unique)

# create a new object "co" with all the fields in them and a new object collection called completeObj
$completeObj = @() 
$co = New-Object -TypeName PSObject

# add all properties to the new collection
foreach ($p in $Properties)
{
    Add-Member -InputObject $co -MemberType NoteProperty -Name $p $null
}

$completeObj += $co

# Now add all existing objects to this new collection
foreach ($o in $objCollection)
{
    $completeObj += $o
}

Forum Discussion

Export-Csv variable object data

Resources