After checking condition of column from data table. Need to put data into build datatable

Help Studio
, ,
1

After getting data into data table, I have used each row and putting If condition to check “Email” column is null or not.
My scenario is If email column is not null then I need to all rows data where email has data in column and store into build data table.

Can i anyone suggest how to do that?

Capture1
Capture1897×466 16.7 KB

2

Hi,

Perhaps you should create DataTable instance before ForEachRow, then use AddDataRow in the loop, as the following.

img20210617-5
img20210617-5581×529 11.2 KB

Or, FilterDataTable activity also might be available, depending on your requirement.

Regards,

3

Getting error while adding add data row

image
image1373×705 31.7 KB

showing error:-Add Data Row: This row already belongs to another table.

4

It’s working now, I have changed dt.

5

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