I have a data table dt1 with a Column name ‘AR Number’ .
I need to update the Colum ‘status’ as success for all the rows matching the ‘AR_Number’ in dt1.
‘AR Number’ value i will be getting in a variable from another data table dt2.
so, AR Number from dt2 when matches in dt1 should be updated with the status.
Below is the dt1 data table having AR Number and status.
if the variable from dt2 contains ‘4000061875’, bot should update the corresponding status in dt1 as success.
Bot should simply check whether the dt2 contains the Ar number present in DT1
if yes status as “success”
if not status as “something as per your requirements”
Yes …bot should check dt1 contains the AR number present in Dt2. if yes then status should be updated for all the rows of that number as success in dt1