Need advise on the best and fastest way to do this.
Let’s say I have a transaction file with 1000 computer names in it, 1 per line.
Then I have a master file with 20000 lines that as part of the line data, contains a computer name but with other attributes.
I need to read the transaction file to get the computer name, then read the master to get an attribute if the record matches on the computer name.
I have tried foreach inside foreach and runs too dam long. I have also tried compare-object and didn’t get far.
What is the best way to accomplish what it is I am after?