Combining Arrays

Question

If I have an this table

"Email","Compliance","DisplayName","Devicename"
"pmichael@globalpsa.com","noncompliant","John Doe","HOMETEST-VM"

and I have another one that looks like this
"Email","Domain"
pmichael@globalpsa.com,Microsoft.com

How do I make it like this
"Email","Compliance","DisplayName","Devicename","Domain"
"pmichael@globalpsa.com","noncompliant","John Doe","HOMETEST-VM",Microsoft.com

Answer 1

$FirstArray      = Import-Csv c:\temp\FirstArry.csv
$SecondArray = Import-Csv C:\temp\SecondArry.csv

Foreach($Row in $FirstArray){
    Foreach($Item in $SecondArray){
        If ($Row.Email -eq $Item.Email){
            $Row | Select Email,Compliance,DisplayName,Devicename,@{n='Domain';e={$Item.Domain}}  
        }
    }
}

Hope this help!

Answer 2

Here's another way to handle this:

$hash = @{}  
Import-CSV C:\Junk\EmailDomain.csv |  
    ForEach-Object{  
        $hash[$_.Email] = $_.Domain  
    }  
Import-Csv c:\junk\EmailCompliance.csv |  
    ForEach-Object{  
        $_ | Add-Member NoteProperty 'Domain' ""  
        if ($hash.ContainsKey($_.Email)){  
            $_.Domain = $hash[$_.Email]  
        }  
        $_  
    } | Export-Csv C:\Junk\Combined.csv -NoTypeInformation  

You'll only make one pass through each CSV this way. Using the technique offered by @Naw the code makes one pass through the 1st CSV but would make as many passes through the 2nd CSV as there are rows in the 1st CSV. For small data sets that my not amount to much, but if there were 1000 rows in each CSV you'd make 1,000,000 passes over the 2nd CSV!

Answer 3

If my table is already in a variable, why it doesn't work if I do it like this

$users |
ForEach-Object{
$hash[$.Email] = $.Domain
}

Answer 4

sorry my bad. I did it this way

$users |
ForEach-Object{
$_ | Add-Member NoteProperty 'Domain' ""
if ($hash.ContainsKey($.Email)){
$.Domain = $hash[$.Email]
}
$
} | Export-Csv C:\Junk\Combined.csv -NoTypeInformation

But I coudn't make it work

Answer 5

If what you want to do (without using CSV files) is to add a "Domain" member to existing PSCustomObjects in an array, then this should work (it's just a slight modification of the code I posted earlier):

$EmailDomain = @()
$EmailCompliance = @()
$hash = @{}
$EmailDomain |
    ForEach-Object{
        $hash[$_.Email] = $_.Domain
    }
$EmailCompliance |
    ForEach-Object{
        $_ | Add-Member NoteProperty 'Domain' ""
        if ($hash.ContainsKey($_.Email)){
            $_.Domain = $hash[$_.Email]
        }
    }