Check the column and update the datatable

I have a query related to datatable.

I have to check each row of datatable and in the Exception column if BE r AE is mentioned then in status column instead of failed need to replace the exception colum value…please refer the img.

Help me in getting this through linq query and also in Uipath activity…


you can use filter data table activity


But I need to replace failed with AE or BE based on the status ryt… how to do that.?

You can simply use for each loop @cbhavana

Inside for each loop check if Exception column is AR or BR then do the certain steps.

For updating the rows check the below threads.

use this sequence
test1.xaml (10.9 KB)
Basically you just loop each row and check the exception value, if AE/BE then update status

Input file
test.xlsx (8.5 KB)
result.xlsx (8.8 KB)

Thanks @jack.chan … I got it.