Picking out a record in a DataTable

[Olaf]

@cxmelga

The above is slow, I want to remove the ‘where’ and find the item in $B directly where the sAMAccountName matches a string (e.g. $item.UniqueID) without going through all the records each time in the loop

Did you try the code suggestion I gave in the other thread?

Speeding up comparision of two CSV file imports

Why don’t you start with something easier to understand? $A = import-csv c:\data\file1.csv $B = import-csv c:\data\file2.csv | Select-Object -Property *, @{Name = 'Name'; Expression = { $_.'here you should provide the property you want to compare' }} Compare-Object -ReferenceObject $A -DifferenceObject $B -Property Name -IncludeEqual -PassThru Assumed you have the data set with the property to compare with the name “Name” in the CSV file “file1.csv” and the data set with the…