How to remove empty row in excel for some specific columns

[sathish_Kumar6 (sathish Kumar)]

How to remove empty row in excel also pic attached for reference

Please take any column after D in excel to remove empty row

[Srini84 (Srinivas)]

@sathish_Kumar6

You can use Filter Datatable activity and mention your column for example F->“campaign” and put is not empty

Then you will get all the values wth the campaign which is not empty

Now use Read Range activity to write it back to a new excel

Hope this may help you

Thanks,
Srini

[arjunshenoy]

Hi @sathish_Kumar6

You can try the following query in the ‘Assign’ activity:

yourDt.AsEnumerable.Where(Function(row) row(2).ToString.Trim.Equals(String.Empty) OR row(3).ToString.Trim.Equals(String.Empty)).CopyToDataTable

This query is basically checking for the 3rd and 4th columns here, but you can include all necessary column indices that you want to check.

Hope this helps,
Best Regards.

[sathish_Kumar6 (sathish Kumar)]

Thank you so much!

[sathish_Kumar6 (sathish Kumar)]

Thank you so much