Powershell: Compare 2 columns with non-unique data

Question

Powershell: Compare 2 columns with non-unique data

Dane Briggs 281

I have been tasked to write a script to import a CSV and determine if each user logs into a laptop, desktop or both. Some users log into multiple computers. I have a CSV of users and computers that they log into. How do I search through a column of the CSV that has duplicates and pull the data from another column and change the output? I feel like I am missing something simple

Example CSV

Example of request output

Rich Matheisen 48,026 Reputation points

2022-05-05T18:35:19.803+00:00

Did you understand the answer to a very similar question you asked yesterday? powershell-searching-array-from-imported-csv-data.html

I'd use the same principal . . . create a hash and if the samaccountname exists as a key check the value. If it's the same, do nothing, if it differs replace it with "Both". When you've processed the whole data set, export the contents of the hash.

If you have a script you think should work but it doesn't, post your script. Also, instead of posting pictures of you sample data upload a file of those data. Nobody like doing data entry.
Dane Briggs 281 Reputation points

2022-05-05T19:04:35.837+00:00

I started to go down that path but ran into an issue.
There are duplicate values in samaccountname and Type. You can't have duplicate keys in a hash.

Since I can't use a hash I'm kind of at a loss as where to start

Sorry about the picture. Here is the raw data from the CSV

Input
samaccountname,Type
contoso\Jblow,Workstation
contoso\Jblow,Portable
contoso\jdoe,Workstation
contoso\Dsmith,Workstation
contoso\Dsmith,Workstation
contoso\BOFH,Portable
Rich Matheisen 48,026 Reputation points

2022-05-05T19:11:55.597+00:00

But you CAN use a hash to do this!

Each samaccountname is a valid key. If it isn't in the hash, add it. Use the Workstation as the value. Get the next row.

OTOH, if the samaccountname is a key in the hash look at the value. If this row's Workstation is different to what's already in the hash, change the value to "both". Get the next row.