How do i delete empty rows after i read range?

[mark_rajkumar1 (mar)]

Hi,

I have read range 3 excel files and save it to datatable. I want to write the datatable by excluding empty rows where i havr read range.
Thanks!

[Yoichi]

HI,

How about to use FilterDataTable activity?

Regards,

[mark_rajkumar1 (mar)]

Hi @Yoichi can give me a detailed step as i am having error saying Column Name is not set

[Yoichi]

HI,

Can you share your input files and expected output as file? it’s no problem if dummy data.

Regards,

[supermanPunch (Arpan)]

Hi @mark_rajkumar1 ,

An Alternate using Linq :

DT = DT.AsEnumerable.Where(Function(x)Not(x.ItemArray.All(Function(x)String.IsNullOrWhiteSpace(x.ToString)))).CopyToDatatable

Here, DT is your Datatable variable.

For Handling Errors related to Direct CopyToDatatable, Check the below post :

[FirstAid] Handling of The source contains no DataRows exception

This FirstAid Tutorial will describe how a the source contains no DataRows EXCEPTION can be handled. Introduction Let’s have a look at the following filter data table scenario: Name CCode Tom US Charlotte FR Seema IN Jean FR Assignment: Filter all rows on a particular Country Code like FR, UK, ES, UK… Ensure that all CCode data column values are trimmed Ensure that the Filter check is case insensitive we can implement it e.g. with the help of a LINQ statement: dtData.As…

[mark_rajkumar1 (mar)]

Hi @supermanPunch i was checking for studiox