Check the column and update the datatable

[cbhavana (BhavanaYadav)]

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…

[fernando_zuluaga]

hey

you can use filter data table activity

regards

[cbhavana (BhavanaYadav)]

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

[shreyash_shirbhate]

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.

How to update a row item in a DataTable using UiPath - RPA Learners

How to change value of existing row and column in a data table

change the value of existing row belonginging to a particular column .and not adding data row.but changing existing value of a datatable

[jack.chan]

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)
Output
result.xlsx (8.8 KB)

[cbhavana (BhavanaYadav)]

Thanks @jack.chan … I got it.