Handling hash table variables

Question

Hi All,

I am referring to the below URL:
https://learn.microsoft.com/en-us/answers/questions/1127027/depender-and-dependee-variable-reallignment.html

@Rich Matheisen , @Aung Zaw Min Thwin - I am trying the below code:

cls  
$source=@(1,2,3,3,3)  
$Entity=@(1,1,1,2,1)  
$Attribute=@(1,5,6,7,7)  
$UsedIn = @{}  
  
   
  
write-host "Entity"  
  
   
  
for($i=0;$i -lt $source.Count;$i++)  
{  
       if ($UsedIn.ContainsKey($source[$i])){  
                     $UsedIn[$source[$i]] += $Entity[$i]  
                 }  
                 else{  
                     $UsedIn[$source[$i]] = ,$Entity[$i]        
                 }  
}  
  
   
  
  
$UsedIn  
  
   
  
write-host "Attribute"  
  
   
  
for($i=0;$i -lt $source.Count;$i++)  
{  
       if ($UsedIn.ContainsKey($source[$i])){  
                     $UsedIn[$source[$i]] += $Attribute[$i]  
                 }  
                 else{  
                     $UsedIn[$source[$i]] = ,$Attribute[$i]        
                 }  
}  
  
   
  
$UsedIn  

Below is the output:

I want to avoid duplicate values for the same key in case if it is coming from the same array. Meaning - I need the below output from the hash table:

1 1 1
2 1 5
3 1 2 6 7

Also, is it possible that when i enumerate the hash table i need to map the value to the corresponding array name. Like,

Key1 has value Entity1 Attribute1
Key3 has value Entity1 Entity2 Attribute6 Attribute7

Answer 1

Avoid the duplicates by looking to see if the array already contains the value before adding the "Attribute" calue:

cls  
$source =       @(1, 2, 3, 3, 3)  
$Entity =       @(1, 1, 1, 2, 1)  
$Attribute =    @(1, 5, 6, 7, 7)  
$UsedIn = @{}  
  
Write-Host "Entity"  
for ($i = 0; $i -lt $source.Count; $i++) {  
    if ($UsedIn.ContainsKey($source[$i])) {  
        $UsedIn[$source[$i]] += $Entity[$i]  
    }  
    else {  
        $UsedIn[$source[$i]] = , $Entity[$i]        
    }  
}  
$UsedIn  
      
Write-Host "Attribute"  
for ($i = 0; $i -lt $source.Count; $i++) {  
    if ($UsedIn.ContainsKey($source[$i])) {  
        if ($UsedIn[$source[$i]] -notcontains $Attribute[$i]) {  
            $UsedIn[$source[$i]] += $Attribute[$i]  
        }  
    }  
    else {  
        $UsedIn[$source[$i]] = , $Attribute[$i]        
    }  
}  
$UsedIn  

Answer 2

you can use the below logic to remove duplicates:

$NewUsedIn = $UsedIn.GetEnumerator() |% { $_.value = ($_.value -split "," | select -unique) -join "," ; $_}  
$NewUsedIn  

Answer 3

If you prefer one liner....

$(for ( $i=0; $i -lt $source.Count; $i++ ) { New-Object PsObject -p ([ordered]@{Source=$source[$i]; E = $Entity[$i]; A=$Attribute[$i] }) }) | Group Source |Select @{n='Source'; e= { $_.Name}}, @{n='E'; e= { $_.Group.E | select -Unique }}, @{n='A'; e= { $_.Group.A | select -Unique }}  

If you want to combine Entity and Attribute:

$(for ( $i=0; $i -lt $source.Count; $i++ ) { New-Object PsObject -p ([ordered]@{Source=$source[$i]; EnA= $Entity[$i],$Attribute[$i]}) }) | Group Source |Select @{n='Source'; e= { $_.Name}}, @{n='EnA'; e= { $_.Group.EnA | select -Unique }}  

rgds,