Powershell: Adding an Array as a member of another array

Question

In Powershell I have 3 arrays similar to the below:

Array1:

Date          Value
----          -----
26/06/2021    5
25/05/2021    10
24/06/2021    4


Array2:

Value
-----
9
8
4

Array3:

Value
-----
11
15
20

I want to be able to add the values from Array2 and Array3 as members of Array1 so it finishes up like the below:

Array1:

    Date          Value    Value2    Value3
    ----          -----    ------    ------
    26/06/2021    5        9         11
    25/05/2021    10       8         15
    24/06/2021    4        4         20

For the life of me i can't find out how to do this - all I have managed to do is add the values from Array2 and 3 to the bottom of Array1 but that is not what I'm after.

Is anyone able to help?

Can you at least provide the code to set the arrays and produce some valid output. — hmedia1
– hmedia1, Commented Jun 25, 2021 at 11:15
Does this answer your question? CMD or Powershell command to combine (merge) corresponding lines from two files. Using this Join-Object script/Join-Object Module (see also: Is there a PowerShell equivalent of paste (i.e., horizontal file concatenation)?): $Array1 |Join $Array2 |Join $Array3 — iRon
– iRon, Commented Jun 25, 2021 at 12:53

Mathias R. Jessen · Accepted Answer · 2021-06-25 11:28:39Z

4

It's not so much that you'll want to add them to the first array - instead, you'll want to create a new array consisting of new objects that have the property values from all three source arrays.

We can create new objects by casting a hashtable literal to [pscustomobject], so all we need to do is align the items in the arrays.

A simple for loop will do:

for($i = 0; $i -lt $array1.Length; $i++){
  [pscustomobject]@{
    Date   = $array1[$i].Date
    Value  = $array1[$i].Value
    Value2 = $array2[$i].Value
    Value3 = $array3[$i].Value
  }
}

edited Jun 25, 2021 at 11:28

answered Jun 25, 2021 at 11:22

Mathias R. Jessen

178k13 gold badges175 silver badges234 bronze badges

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

1 Comment

hmedia1 Over a year ago

+1 on the concise iteration. Something maybe helpful (or not) to add would be that if you wish to refer to say $Array1.Value2 or $Array1.Value3 etc.. then you could set the above into $Array1: $Array1 = for($i =0 ..... etc...

Collectives™ on Stack Overflow

Powershell: Adding an Array as a member of another array

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related