Vlookup Excel1

Help Activities
, , ,
1

Hi all,

I have 2 different Excels, I need to do Vlookup from Excel1 Column Cust ID to Excel2 Column Acc Num.

Can anyone please help me how to do Vlookup?

Thanks in advance

2

Hi @amitha.aenugula

You can use the Vlookup activity.

Hope it helps!!

3

Hi @amitha.aenugula

image
image679×722 27.5 KB

4

I need to use linq as I have huge data in excel lookuo datatable is taking more time

5

Can anyone Please help me

6

Hi @amitha.aenugula

Can you please share sample excel files with dummy data.

Regards,

7

(From row1 In Dt.excel1.Asenumerable() Join row2 In Dt.excel2.Asenurable() On row1(“Cust ID”).tostring() Equals row2(“Cust Id”).tostring()
Select New With {.CustID = row(“Cust Id”).tostring(),.ACCnum=row2(“Acc num”).tostring()}