How to find column values of datatable is null

Help Studio
, ,
1

Hi All,

I have one data table which has telephone numbers. i need to pass these telephone numbers to web page and verify is present or not i used for each row and verifying telephone numbers. if the telephone numbers are not present in webpage i need to go other flow.

how to find datatable entire column status is null

Regards,
Hima

2

@thima

we can use folowing statement for a check

isNothing(yourRowVar(YourColNameOrIndex)) OrElse String.IsNullOrEmpty(yourRowVar(YourColNameOrIndex).toString.Empty)

Statement returns true if column value is null, blank / empty

Maybe filtering the datatable before on empty column values and processing the filtered result could also be an option adressing the task