I have a working process to loop through two datatables and if the row of DT1 = row DT2, then assign the variable to a new DT3
The files I’m working with are rather large, approximately 100k and 2k rows. The process takes about 20 minutes to run and essentilly performs a “VLookup” between the two datatables.
I’ve searched the forums on alternative solutions, however, there are a ton of different options and I’m unfamiliar enough with them to make an educated assessment. Can anyone please provide their input on how to make my process more efficient?
My tables are listed below.
UniqueName, Email Address
DT3 - Output
UniqueName, PO#, Email Address
Thanks in advance!