Checking Duplicate rows depending on the condition

Help
,
1

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

image
image1330×187 7.89 KB
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.

3

@sindhujaj

  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
5

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.

6

can u send me in workflow

7

have you solve it ?

8

Yes…Thanks for the reply

9

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