If blank column present in any row then get that whole row and append new sheet

Help Studio
, ,
1

if blank column present in any row then get that whole row and append new sheet

Ex : blank column in 1006 row then I have get whole row and append in new shhet

image
image851×214 83.9 KB

Thanks
Shaik

2

Hi @shaik.muktharvalli1

Assign activity:

newDataTable = originalDataTable.AsEnumerable().Where(Function(row) row.ItemArray.All(Function(field) String.IsNullOrWhiteSpace(field.ToString()))).CopyToDataTable()

Hope it helps!!

3

can you suggest how to in for each in data table

Thanks
Shaik

4

@shaik.muktharvalli1

Use For each row in datatable
  if
   String.IsNullOrEmpty(row("Column1").ToString()) OrElse String.IsNullOrEmpty(row("Column2").ToString()) OrElse String.IsNullOrEmpty(row("Column3").ToString())
  Remove data row

image
image718×670 26.7 KB

Hope it helps!!

5

@shaik.muktharvalli1

IF you are using for each row in datatable activity.
Use If activity inside the for each row in datatable activity

Condition as

CurrentRow.ItemArray.any(Function(a) string.IsNullOrEmpty(a.ToString.trim))

Then use append range activity to append it to the new sheet