Update cell with linq

[Juan_Esteban_Valencia]

Hello everyone

I need to update the excel cells that meet certain conditions, for example, I have the code column and the batch column, if the value of the code column is equal to “CM84” and the value of the batch column begins with “CM” I need that the value of the code column changes and is “CM28”

I solved this with a for each in data table, but due to the amount of data that I have in the file it is not the best solution, that is why I am trying to solve it with a linq

[sharon.palawandram]

hi there, you can try this.

Instead of updaing column C, you can update column B.

dt = dt.AsEnumerable.Select(Function(r) dt.Clone.LoadDataRow({r(“Col A”),r(“Col B”),if(r(“Col A”).ToString.Contains(“Needed”) AndAlso r(“Col B”).ToString.ToUpper=“TRUE”,“Present”,r(“Col C”)) ,r(“Col D”)},False)).CopyToDataTable

Compare two column and update to another column through linq

linq.xlsx (8.3 KB) Hello All, I want to write linq query to check two column Col A and Col B "If Col A contains “Needed” and col B contains “TRUE” then update to Col c = “Present” else remaining are same as it. Please help me to find the solution. [sslinq]

[sharon.palawandram]

How to compare 2 columns if they are equal and output it on a new column using LINQ

give a try on following Clone your datatable (ensure the Result column holding failed, success is not present) - dtResult Add a datacolumn (should be on end of columns) ColName Result Assign activity Left: dtResult right (From d in dtData.AsEnumerable let chl = d(Col1).toString.Trim.Equals(d(Col2).toString.Trim) Let res = If(chk, “Success”, “Failed”) Let ra = d.ItemArray.Append(res).toArray Select r=dtResult.Rows.add(ra)).CopyToDataTable

[Juan_Esteban_Valencia]

Hello, thank you very much, I had already seen these posts, but in the first one that you shared with me I have not been able to change only column B, that script always changes column C and only selects columns from A to D, I need that the file remains intact and only the cells that meet the conditions are changed (the file contains about 50 columns)

[postwick (Paul)]

LINQ doesn’t avoid looping. It still loops inside the LINQ engine. It’s a myth that LINQ is faster. In fact, LINQ can be slower because it introduces more overhead.

[Gokul001 (Gokul Balaji)]

Hi @Juan_Esteban_Valencia

Have a look on video

How to update column values in Data table using Linq | Linq Query in uipath - Part 9

Regards
Gokul

[Veera_Raj (Veeraraj Sethuraman)]

(From r In DT_Data.AsEnumerable Let ra = r.ItemArray.Select(Function (x) x.ToString.Trim.Replace(" ",“NA”)).toArray() Select DT_Data.Rows.Add(ra)).CopyToDataTable()

you can try this