VLookup in Linq

Hi Team,
i have a datatable as pasted,
image

if price is given i need to Extract Name, i knew i can achieve it through Lookup Activity in UiPath… but i am trying to achieve it through LINQ … can anyone guide.

we can do it e.g. with the help of a LookUpDict

dictLK | Dictionary(Of String, String) =

dtData.asEnumerable.ToDictionary(function (x) x("Amount").toString.Trim, function (x) x("VendoName").toString.Trim)

then a dictLK (“300”) will return Deva.

But keep in mind: Amounts has to be unique or we would need a different logic

As an alternate we would implement a LINQ filter or Join case

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.