- Uređivano
chono Ajmo preko hashtable keyeva (poljeAD konverzija objekta u key vrijednost helperpolja - powered by stackoverflow):
Write-Host 'Hello Chono, lets take you for a ride!'
$polje1 = @([pscustomobject]@{email="email1@email.com";date="04/19/2022";RealName=""},
[pscustomobject]@{email="email2@email.com";date="04/18/2022";RealName=""})
$poljeAD = @([pscustomobject]@{date="04/19/2022";SamAccountName='userName1';RealName="Real Name hehehehehehe";Office='Office 1';email='email1@email.com'},
[pscustomobject]@{date="04/18/2022";SamAccountName='userName2';RealName="Real Name 2";Office='Office 2';email='email2@email.com'},
[pscustomobject]@{date="04/17/2022";SamAccountName='userName3';RealName="Real Name 3";Office='Office 3';email='email3@email.com'})
$helperPolje = @{}
$poljeAD | ForEach-Object {
$helperPolje[$_.email] = $_
Write-Host $helperPolje[$_.email].email
}
$polje1 | ForEach-Object {
$email = $_.email
if($helperPolje.ContainsKey($email)){
Write-Host "Entered the loop"
$_.RealName = $helperPolje[$_.email].RealName
}
}
Write-Host "Expanded data for polje1 $($polje1[0].email): $($polje1[0].RealName)" `
[URL=https://i.imgur.com/WMEhBuI.png][IMG]https://i.imgur.com/WMEhBuI.png[/IMG][/URL]
EDIT (malo bolje napisano, bez da imaš prošireno polje1):
`Write-Host 'Hello Chono, lets take you for a ride!'
$polje1 = @([pscustomobject]@{email="email1@email.com";date="04/19/2022"},
[pscustomobject]@{email="email2@email.com";date="04/18/2022"})
$poljeAD = @([pscustomobject]@{date="04/19/2022";SamAccountName='userName1';RealName="Real Name hehehehehehe";Office='Office 1';email='email1@email.com'},
[pscustomobject]@{date="04/18/2022";SamAccountName='userName2';RealName="Real Name 2";Office='Office 2';email='email2@email.com'},
[pscustomobject]@{date="04/17/2022";SamAccountName='userName3';RealName="Real Name 3";Office='Office 3';email='email3@email.com'})
$helperPolje = @{}
$poljeAD | ForEach-Object {
$helperPolje[$_.email] = $_
}
$polje1 | ForEach-Object {
$email = $_.email
if($helperPolje.ContainsKey($email)){
Write-Host "Entered the loop"
$_ | Add-Member -MemberType NoteProperty -Name 'RealName' -Value $helperPolje[$_.email].RealName
}
}
Write-Host "Expanded data for polje1 $($polje1[0].email): $($polje1[0].RealName)"
Probaj na pravim podacima ako nisi pa javiš (pazi samo, ovaj forumski editor mi je maknuo sve underscore znakove, tam gdje je italik išao je underscore prije tog dijela)...