Hey guys, Can someone create process for Vlookup two files attached using linq query and send me .xaml file? Files excel.7z (171.1 KB) I created process using LookupDataTable, but it takes 2.5 hours to perform lookup. Screen of the files in the picture below: [File1_File2] In the result I need: …

Vlookup column from one excel file into another using linq query

ppr (Peter Preuss) September 30, 2020, 9:07pm 3

@Apple1
Find starter help here:
Appl1_VLookup_LINQ.xaml (10.8 KB)

feel free to change to column names instead of column index. Adopt the paths to Excel as by your environment

3 Likes

Vlook up using LINQ in UI path

Topic		Replies	Views
VLookup on two excels using LINQ Studio studio , question , activities_panel	3	1337	March 18, 2022
Use vlookup on filtered data Studio studio , question , activities_panel	4	847	August 13, 2022
Vlookup column from one excel file into another Academy Feedback studio	19	1887	September 30, 2020
LINQ Vlookup Studio studio , question , activities_panel	1	847	September 11, 2022
Use vlookup with Linq and TWO DATATABLES Activities excel , activities , question	15	4010	November 17, 2021