How to pickup blank row by filter activity

[Takayuki1 (Taka)]

Hello All,

I want pickup blank row only by filter activity. But can’t filtering by blank row.
How to pickup blank row by filter activity?

Regards,

[arivu96 (Arivazhagan A)]

Hi @Takayuki1 ,
use below syntax to filter only blank rows
dt.Select("Coment=''").CopyToDataTable()

Regards,
Arivu

[Anil_G (Anil Gorthi)]

@Takayuki1

Please click on configure → advanced filter → Is Empty

Cheers

[Gokul001 (Gokul Balaji)]

HI @Takayuki1

In the Filter activity try like this in the image and let us know if you have issue

Regards
Gokul

[Sudharsan_Ka]

HI @Takayuki1

In that filter activity give your Source and column name

In the Configure field Clikc on advance filter and then give isEmpty

Regards
Sudharsan

[Gokul_Jayakumar (Gokul Jai)]

Hello @Takayuki1

1. You can use this activity inside the Excel application scope
2. Pass the range and mention the column Name
3. In configuring filter, the Basic filter is equal to “” (Empty Double quotes)
   

[Gokul_Jayakumar (Gokul Jai)]

@Takayuki1
You Can also use the Filter Data table

1. use Read range and read excel data and stored it in DT
2. Use filter data table and pass the Input as DT as well as output as DT
   2.1 Enable the Keep option
   2.2 Column name can give as Index or actual name and operation is Is Empty
3. Then Write the data into a separate sheets using the write range activity
   
   

[Takayuki1 (Taka)]

Hello All,
THank you for your quick replay. I can fix this query.

Regards,