How to get row from another DataTable using linq?

[prabin_chand1 (RoboChan)]

Hello !
I have two datatable, I want to search name from DT1 in DT2 and if name exitsts i want to get row from column “Emails” in DT.

How can i do that ?

[Gokul001 (Gokul Balaji)]

Hi @prabin_chand1

You can try with LookupData Table activity

https://docs.uipath.com/activities/other/latest/user-guide/lookup-data-table

Regards
Gokul

[Jithesh_R (Jithesh Karkera)]

Hey @prabin_chand1 ,
I believe you can do this by inner join method
Try this,

(
From a In DT1
Join b In DT2
On a("Name").ToString Equals b("Name").ToString
Select OutputDT.Rows.Add({a("Name"),b("Email")})
).CopyToDataTable

Regards,

[prabin_chand1 (RoboChan)]

I cannot use Equals as Name are different in length . Therefore i need to use Contains method.

How can i use contains method in above code ?

[Sanjit_Pal]

Hey @prabin_chand1 ,

Have a look at this thread.

How to select rows from a data table using Linq but with reference to an array

Hello, I have a data table that has some client ids, names, and countries, I have another array that has the client ids I require for the process ( example: id={1011,1015}). Is there any chance where we can directly get the rows where ClientID is the same as array element? [image] Here is the example excel file. testData.xlsx (8.4 KB) Thanks in Advance

Thanks,
Sanjit

[Nitya1 (Nitya Tomar)]

To search for a name in DT1 and get the corresponding row from column “Emails” in DT2 in UiPath, you can follow these steps:

1. Use the “Lookup Data Table” activity to search for the name in DT2.
2. Configure the “Lookup Data Table” activity by specifying the input parameters:a. In the “Input” field, select DT2 as the DataTable you want to search.b. In the “Lookup value” field, specify the name you want to search for from DT1.