How to find column value is blank and update the status without using Loop

[jeevith (Jeevith Hegde, Ph.D.)]

Hi @nithya,

Your request of not using loops for performance reasons is not correct. Please read this thread to know more about the two approaches: standard loops (which in the backend probably already use linq) vs. standalone linq query in UiPath.

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

I’ve seen the discussion many times about avoiding For Each (Row) because looping through a lot of rows is inefficient. So I wrote a test. It creates a datatable of however many rows we want (Name, Age, City). Default values are Mary, 28, Dallas. Every 10th row is Tom, 27, Miami. Goal is to update Tom to Boston. [image] The first method is simply a single For Each with nested Assign to change Tom’s City to Boston. [image] This is the method of filtering into two separate DTs so you ha…

As per the approach you can use.
You can use a for loop or nested loops and build up all the logic to find where the edits need to be made and when an index matches those conditions, update the status column with the required string and later write it to excel.