Add column with condition without loop

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

Hi @SakshiGupta,

Your request of “Without loop” is not achievable. Such a thing does not exist. Without iteration none of the approaches will work.

Standard for each row activity is more than sufficient for your case.

Standard UiPath activities are not slow. Please read this excellent thread / test from @postwick to see the test results.

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…