How to check each row from column if continuously dropping less than 3 then break the loop and send exception mail

Help Studio
, ,
21

with an modification of the given approach from your other topic it can be done

Also it can be done completely by only using essential acitivites

  • loop over all rows
  • check if value < 3
    • then: add it to a list - check list on length / constant decreasing value series
    • else: reset list
22

first sort the data table based on the particular column. inside the loop set the counter variable as 0 then check loop index is greater than or equal to 1 inside that use assign activity and retrieve previous row value. after that use another if to check if current row value less than previous row value. If satisfied in then part increase the counter variable by 1. use another if check counter variable = 2 (which means 3 consequtive down as u mentioned), then send exception mail and change the counter variable value to 0 again

23

@Ramya_25 can you send sample workflow please

Thanks
Shaik

24

@ppr please send sample workflow … :pray:

Will understand easily please

Thanks
Shaik

25

Hi,

Try this.

In the For each → Enumerable.Range(1,InputDt.rows.count-1)

1715062038900370814163219874347
17150620389003708141632198743471920×1440 304 KB

17150621878205169906334614353307
171506218782051699063346143533071920×1440 254 KB

Regards,
Harish

26

@HarishGnanakumar Let me check and confirm

thanks
shaik

27

thank you @HarishGnanakumar

28

@HarishGnanakumar Thank your logic correct

I need get row value where get exception please

Thanks
Shaik

29

Hi Shaik,

To get the whole row - InputDt.Rows(rowIndex)

To get the Specific Column -InputDt.Rows(rowIndex).Item(“Column name”)

Error occured row index will be - rowIndex

Rows which caused the exception - rowIndex,rowIndex-1,rowIndex-2

30

ok thanks soo much @HarishGnanakumar

let me check and confirm

31

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