Check for empty cell in build data table output

[Sudharsan_Ka]

I have task like I need to find whether the build data table output table have a empty value
In any of the row or column
Eg:
I am having 3 rows and n number of column added in build Datatable activity
I need to check whether the output Datatable is having any empty values
@prasath17 bro can you help with this task

Thanks in Advance

[prasath17 (Guru)]

@Sudharsan_Ka - Please refer this post…

Check if a datatable contains rows with Null or Blanks in any Column/Cells

Hey everyone, I want to check if a datatable contains any null or empty values, DT.AsEnumerable.Any(Function(x)String.IsNullOrEmpty(x(“column name”).ToString)) i use this for making the same check on a column but I want to chec the whole datatable. Any help? I dont want to copy paste the above code for all columns or use a for each loop since there are alot of columns and rows. Ty,

Assign the code provided here to Boolean value as shown below.

Hope this helps…

[Sudharsan_Ka]

Thank you bro ,works fine