Fetch value form datatable

Help
1

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

image
image871×390 5.77 KB

need suggestion/help.

2

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

then whatever you want to do in the else.

2 Likes
3

Fine
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
4

@indrajit.shah,

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
5

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.

6

Cheers @indrajit.shah

1 Like
7

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

1 Like
8

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

9

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