Linq query to update cell of a row item based on another cell value from same row

[shivarajvp555 (SK)]

Hello all,

I have a requirement for which i need to implement linq query , i am sharing the requirement below :
I have 2 data tables dt_invoice&Comments , and dt_master
first data table dt_invoice has invoce numbers lets say A101,A102,A103 etc. in invoice column and second column for the dt_invoice&comments has comments.
I need to search each invoice of dt_invoice&comments in dt_Master data table , whenever a match found in second data table i.e, dt_master, i have to update a cell value for found invoice in the dt_master, this cell value is nothing but the comment we have in dt_invoice&comments for the respective invoice.

Can someone suggest how to build linq query for the same.

Appreciate your help, in advance.

Regards,
Shiva

[ppr (Peter Preuss)]

have a look here for the basic concepts:

Story line of Join Data Table

Dear innovator’s, All we know that there is a Join Data table activity in UiPath.If we get any matching scenarios with unique value will approach join data table activity instead of filter/loop/array matching activity to find an exact match. Join Data Table: [image] Combines rows from two tables by using values common to each other, according to a Join rule, which is specified in the Join Type property. Sample Table: [image] INNER Join: The INNER JOIN keyword selects records that have m…

once the joining / pairing / lookup is cleared we can translate it to a linq

For LINQ Practice have a look here:

[HowTo] LINQ (VB.Net) Learning Catalogue

This topic references the different Learning HowTos related to LINQ. It will be updated on new published HowTos as well LINQ Learning: Topic LINK First Start with LINQ [HowTo] - First Start with LINQ (VB.Net) Exploring the LINQ universe [HowTo] - Exploring the LINQ Universe (VB.Net) Operator [HowTo] Overview Topic LINK Where [HowTo] LINQ - First Start # Where Operator Select work in progress Any [HowTo] LINQ – First Start # Any Operator All [HowTo] LINQ – First Start…

[Jayesh_678 (Jayesh)]

Hi,

Try this:-

Assign activity to get list of query:-

query = from DataRow invoiceRow in dt_invoiceComments.Rows
join DataRow masterRow in dt_master.Rows
on invoiceRow[“invoice”] equals masterRow[“invoice”]
select new { Invoice = invoiceRow[“invoice”], Comment = invoiceRow[“comment”], MasterRow = masterRow };

Then use for each, item in a query

Assign activity
item.MasterRow[“your_cell_column_name”] = item.Comment;

Thanks

[shivarajvp555 (SK)]

Thanks for sharing! , this will really helps.

[Jayesh_678 (Jayesh)]

Hi,
I am glad that it helps you…
Please mark this as a solution. So others can refer the same.

Thanks