How to fetch row with empty field in a datatable?

Input file:
TestNew.xlsx (11.8 KB)

In this file they are some empty fields , how can i fetch that particular entire row and should store in some variable .

HI @Soundarya_Guduri

You can try with Filter Data Table activity

Check out the blog

Regards
Gokul

Check out the XAML file @Soundarya_Guduri

EmptyRowUsingFilter.xaml (6.3 KB)

image

Regards
Gokul

Thankyou for your quick response.
Sometimes postal code will be empty, or suburb in this case how to fetch empty field row.

If this is the case how should we approach. please let me know.
Consider this sample input file.
TestNew.xlsx (11.8 KB)

Use or in the filter data table activity and do the same like the above one @Soundarya_Guduri