Continue to the next 100 rows if the first 100 rows not match

Help Studio
, , , ,
1

Hello, I have a question.

In case I have 500 rows. I need to loop the first 100 rows and see if the total amount matches with amount on a website. If it not matching, then I send an email to the user and continue to the next 100 rows. How can I do so?

1 Like
2

@Syasya

Welcome to the community.

Dt.asenumnerable.chunk(100).select(Function(a) a.copytodatatable).toarray

The output of the expression is array of datatables

Use for each activity for the array of datatables

And uses the condition to check whether in that any value matches or not

currentItem.asenumnerable.any(function(a) a(“columnname”).tostring.equals(websiteamountvariable))

Gives you the booloutput and in then block use send outlook mail activity

Here currentItem is a datatable consists of 100 rows for each iteration.

2 Likes
3

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