Fetch value form datatable

below is the image from my datatable, i need to perform no action if DC Number value is No Data.

need suggestion/help.

Put a simple if inside the foreach row loop.
row(“DC Number”).toString.contains(“No Data”)

then whatever you want to do in the else.


we can use this expression to do that
–use a assign activity like this
yourdatatable = yourdatatable.Select("[DC Number] <> ‘No Data’ ").CopyToDatatable()
–then use a FOR EACH ROW activity where use the datatable variable as input
and that datatable wont have value with No Data as value in it

Cheers @indrajit.shah

1 Like


If you are using this table data to perform your operation then check this condition in a IF activity.

Not (yourDataTable.Rows(0)("DC Number").ToString.Equals("No Data"))

This will avoid the activities inside the IF activity’s True Part side.

1 Like

thank you @Palaniyappan, i was looking for something like using if condition where if my condition is meet with “No Data” then i will end the loop else it will continue.

Cheers @indrajit.shah

1 Like

do you mind checking your inbox, i had send you an message.

1 Like

aah let me check
sorry for that
one min pls
Cheers @indrajit.shah

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