How can I efficiently delete rows with missing values in a DataTable?

Help Studio
1

Besides performing a “Filter Data Table” operation on all columns, are there any faster methods to delete rows with missing values in a datatable?

2

HI,

Can you try the following sample?

image
image857×1230 35.6 KB

Filter out rows which has one blank at least

arrDr = dt.AsEnumerable.Where(Function(r) not r.ItemArray.Any(Function(o) o Is Nothing OrElse String.IsNullOrEmpty(o.ToString))).ToArray()

OR

Filter out rows which all blank

arrDr = dt.AsEnumerable.Where(Function(r) not r.ItemArray.All(Function(o) o Is Nothing OrElse String.IsNullOrEmpty(o.ToString))).ToArray()

Sample
Sample20240815-2.zip (3.4 KB)

Regards,

3

Hi，

I cannot open your sample file, possibly due to version issues, but the solution is effective.

I will remember to bring the software version next time, it was my oversight.

The image shows an error message from UiPath stating "Document is invalid" with details indicating missing system collections in the assembly 'System.Private.CoreLib'. (Captioned by AI)
The image shows an error message from UiPath stating "Document is invalid" with details indicating missing system collections in the assembly 'System.Private.CoreLib'. (Captioned by AI)1092×678 29.2 KB

The image depicts a sequence of activities in a workflow, including an assignment operation, a conditional "If" statement, outputting a data table, and logging a message. (Captioned by AI)
The image depicts a sequence of activities in a workflow, including an assignment operation, a conditional "If" statement, outputting a data table, and logging a message. (Captioned by AI)739×628 18.9 KB

Your solution is super efficient! I really appreciate your warm-hearted help.

Regards，

1 Like
4

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.