VLookup on two excels using LINQ

[Sirisha_Siri]

Hi,
I need to perform VLookup on two excels using LINQ query.
Can someone create process for Vlookup two files attached using linq query and send me .xaml file?
I created process using LookupDataTable, but it takes 4.5 hours to perform lookup for large data. I tried LINQ query but its not giving output. Can someone pls check and correct me. Please find the sample .XAML

SampleLookup.xaml (7.8 KB)

Below are the sample input files.
input2.xlsx (10.3 KB)
Input1.xlsx (550.4 KB)

Required output:
Column “Transaction Confirm Number” from input1 Excel has to check with the Column “Transaction Confirm number” in input 2 Excel, and write the “material documents” values that has matched with “Transaction Confirm numbers” from input 2 excel,Output has to be written to “Material Documents” Column in Input 1 excel.

[Sirisha_Siri]

@ppr , @ashwin.ashok @Palaniyappan can someone help plss

[Sirisha_Siri]

heyy… i solved it

[Sanjit_Pal]

@Sirisha_Siri this below solution might be helpful

Vlookup column from one excel file into another using linq query

Hello @Apple1! It seems that you have trouble getting an answer to your question in the first 24 hours. Let us give you a few hints and helpful links. First, make sure you browsed through our Forum FAQ Beginner’s Guide. It will teach you what should be included in your topic. You can check out some of our resources directly, see below: Always search first. It is the best way to quickly find your answer. Check out the [image] icon for that. Clicking the options button will let you set mor…