Checking Duplicate rows depending on the condition

Hello hi,
Can u please help me in solving the issue

in this excel i want to check whether the status is Positive or Negative.If positive no Problem, but if it is Negative check the job no. for Negative is repeated.


  1. Use Read Range Activity to read the data from excel file and will give you output as DataTable and say ‘inputDT’. And then try below expression to get status column contains negative word or not.

          negativeDT = inputDT.Select("Status Like 'Negative%'").CopyToDataTable

After getting the -ve rows in a datatable, can iterate through each row using the foreach row activity and then check the duplicate of each job if a duplicate found then fetch its status.

can u send me in workflow

have you solve it ?

Yes…Thanks for the reply

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.