Split up object array into rows

Question

Consider a function that returns a list of object X where X has an integer and an array of objects.

Get-Foo

MyInteger   MyStrings
---------   ---------
        1   {A,B,C,D}
        2   {A,B,C}
        3   {A}

How do I perform a self-join of this list in order to get the output below?

Get-Foo

MyInteger   MyString
---------   --------
        1   A
        1   B
        1   C
        1   D
        2   A
        2   B
        2   C
        3   A

mjolinor · Accepted Answer · 2015-02-16 14:40:15Z

2

Just iterate through MyStrings on each object, and create a new object for each one:

function get-foo {
[PSCustomObject]@{MyInteger=1;MyStrings=@('A','B','C','D')}
[PSCustomObject]@{MyInteger=2;MyStrings=@('A','B','C')}
[PSCustomObject]@{MyInteger=3;MyStrings=@('A')}
}

get-foo | 
foreach {
 foreach ($string in $_.MyStrings)
  { [PSCustomObject]@{
     MyInteger = $_.MyInteger
     MyString=$string
    }
   }
 } | ft -AutoSize

MyInteger MyString
--------- --------
        1 A       
        1 B       
        1 C       
        1 D       
        2 A       
        2 B       
        2 C       
        3 A

answered Feb 16, 2015 at 14:40

mjolinor

68.7k7 gold badges118 silver badges141 bronze badges

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

2 Comments

l33t Over a year ago

Thanks a lot! Is foreach necessary to accomplish this? I struggled hard to get it working using piping only.

mjolinor Over a year ago

If you want to do this in the pipeline,you might want to look at the -PipelineVariable parameter in V4. Don't know whether that will work with your function or not, though.

Collectives™ on Stack Overflow

Split up object array into rows

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related