I receive two Excel file 1. CSV file having all the data. 2. xlsx file format having Emp_Id in CSV file i have lot of data like more than 50,000 data i need to compare both the file and find the location which we have input in xlsx format (Emp_id)
Which one is fast and accurate look up data table or LINQ?
Can u please suggest and give a LINQ or lookupdata table steps please.
use 2 assign activitys
converting the first datatable to dictionary
dict_cityvalues=dt1.AsEnumerable.ToDictionary(Function(a) a(0).ToString,Function(a) a(1).ToString)
Read both into datatables and then use Join Data Table
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.