Powershell handle two variables based on the same name, like SQL join [duplicate]

Question

My first variables, is someting like: name OS version ---- ---- kead windows 2019 hanacockpit SLES12SP3 My second variables, is like

name GB ---- ---- kead 54.081582998856902122497558594 hanacockpit 384.20552698988467454910278320

As you can see the first column is name, as long as the second one has the same name,let's say kead,Join GB accordingly.

The final output is name OS version GB ---- ---- --- kead windows 2019 54.081582998856902122497558594 hanacockpit SLES12SP3 384.20552698988467454910278320

Anyway to do it?

Actually, variable1 and variable2 are from ESXI powercli.

# skip connection.

$all=Get-VM | 
   Get-View -Property @("Name", "config.GuestFullName") | 
   Select -Property Name,
       @{N="OS";E={$_.Config.GuestFullName}}

$space =get-vm | Select Name,@{N="disk-size";E= {@([math]::Round($_.ProvisionedSpaceGB / 1))}}

there are at least two merge or join modules in the powershell gallery site that seem able to handle that sort of thing. — Lee_Dailey
– Lee_Dailey, Commented Mar 19, 2020 at 10:25

Kyle Ruddy · Accepted Answer · 2020-03-19 22:00:10Z

0

Maybe it's not quite what you're asking for, but you could just re-write your command into a one-liner...

Example:

   Get-VM | Select Name, @{N="OS";E={$_.ExtensionData.Config.GuestFullName}}, @{N="disk-size";E= {@([math]::Round($_.ProvisionedSpaceGB / 1))}}

If you're just looking for the join, my preference has generally been Join-Object: https://devblogs.microsoft.com/powershell/join-object/

answered Mar 19, 2020 at 22:00

Kyle Ruddy

2,1211 gold badge9 silver badges5 bronze badges

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

Collectives™ on Stack Overflow

Powershell handle two variables based on the same name, like SQL join [duplicate]

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related