Dear Forum Member, I have a scenario where i have two data table dt and dt1. in dt there are two column A and B. In dt1 there are also two column C and D. My problem is if the any value of column C from dt1 matched with any value of column A of dt then the value of column D for matched row must be…

Hi @Yankit_singh , Use join data table activity instead of linq. You can apply your condition in that activity refer below link for more info Join Data Tables UiPath.Core.Activities.JoinDataTables Combines rows from two tables by using values common to each other, according to a Join r…

Hi @Yankit_singh , Refer below post [image] DataTable filtering with expressions Tutorials Hi All, Use below code to remove empty row from the table. DataTable name->DataTableName Use assign activity DataTableName=DataTableName.Rows.Cast(Of DataRow)().Where(Function(…

@arivu96 Thanks for the reply. But i didn’t find any LINQ Query related to my problem. Can you please share the exact query. Thanks in advance.

You are not obliged to use LINQ in your case. For Each loops can do the same work here. [image] Lookup in excel Studio Oh, it was better if you have mentioned that the data was large, but it’s okay. Some tweaks we can do are: [image] 1-10-2022.xaml (10.3 KB) Best, Ch…

you can do it with a left join LINQ statement

Data table column value match

Help Studio

arivu96 (Arivazhagan A) January 11, 2022, 6:34pm 2

Hi @Yankit_singh ,

Refer below post

Regards,
Arivu

Topic		Replies	Views
How to look column 1, column 2, Column 3 in Datatable1 to column1 Column 2,column3 in Data Table 2 note Column headers are different Activities datatable , excel , activities , studio , question	14	854	September 1, 2023
How to Filter Column of First Data table with Respect to Column of Second Data Table using Linq or Select Query Studio datatable , excel , studio , question , workflow_analyzer	3	1589	December 16, 2021
Values match of two column of data table Studio studio , question , activities_panel	6	986	September 22, 2021
Compare two tables and write data only for same values Studio	5	1875	September 13, 2021
Check in dt2 if dt1 Column Value occurs - Write Result to dt1 Studio studio , question , properties_panel	6	1596	February 2, 2022

Data table column value match

Related topics