There is no need to try to avoid For Each loops on large amounts of data

[ppr (Peter Preuss)]

Cross References

LINQ vs Loops like for, for each and while

@Surya_Narayana_Korivipadu Just a few thoughts on this topic (preview of a howTo topic that is currently in preparation) Task: update data columns in general, we should start with a for each (sometimes also for each row) activity. We can combine it with some LINQ in case we want to filter in advance to reduce the number of rows. If for any reason we want to do it with an invoke code activity we should mirror the for each activity instead of writing LINQ complexes. But for sure we can combine…

Update specific column for specific row value without using for each

I want to update a specific column value for the specific row (same value with more than one row) in excel

Replace blank column value with specific value using linq

we would suggest to do it with a for each row activity loop. For learning purpose a LINQ could look like this For Each row As Datarow In dt.AsEnumerable().Where(Function (r) IsNothing(r("Column1")) OrElse String.IsNullOrEmpty(r("Column1").toString.Trim)) row("Column1") = "Undefined" Next used within Invoke Code Here we only do use LINQ for the filtering and do mirroring the for each activity on code. Updating is stressing the LINQ concept and results quickly to avoidable black box approac…

LINQ query to replace column datatable in uipath

@MarkusDS Feel free to open a seperate Topic on it or reach me by message. The most important factor on an implementation is maintainability and that there is a chance to track the processing. Using a Linq in an Assign statement is forcing that the LINQ Statement is returning something (L-Value assignment). Updating a column will fail: ) dt.AsEnumerable.Where(Function ( r ) r.Field(Of Int32)(0) < 2).Select( <- return is needed ) other tricks e.g. return someting and do col update will not v…

How to Update Data Column Values of a Data Table | Community Blog