Vlookup with LINQ code

Help Studio
, , ,
1

Hello guys,

I want to do a process which is going to bulk update inside an sql table. I did it with excel process scope and vlookup activity. But it takes long time. I have to do it like 15000 items per each query.

So I have an excel which has two sheets ;
First sheet is table one which has a table from my querry ;

uıpathforum1
uıpathforum11408×990 308 KB

Second sheet is the table which has my CategoryId and values;

uıpathforum2
uıpathforum21387×991 230 KB

I have to match categoryıd and do vlookup for Height,Depth,Width,Modifieddate values.

Here is my excel file ;
xxx.xlsx (455.7 KB)

I just need a LINQ code for it. Thanks for your answers. Here is my process ;

image
image1456×813 38.2 KB

2

@arif_samet_ipek

can you try this using invoke code activity

Dim counter As Int32
For Each r As datarow In dt1.AsEnumerable
If dt2.AsEnumerable.Any(Function(b) b("CategoryId").ToString.Trim.Equals(r("CategoryId").ToString.Trim)) Then
	counter=dt2.AsEnumerable.ToList.FindIndex(Function(a) a("CategoryId").tostring.Equals(r("CategoryId").ToString.Trim))
	r("Height")=dt2.rows(counter).Item("Height").ToString
	r("Width")=dt2.rows(counter).Item("Width").ToString
	r("Depth")=dt2.rows(counter).Item("Depth").ToString
	r("ModifiedDate")=dt2.rows(counter).Item("ModifiedDate").ToString
End If
Next

image
image1108×678 38.6 KB

Final output you will get in dt1