Bulk Add Queue Items - Extra Null Values getting uploaded

A Cleansing LINQ, checking a paticular datatable column and removing blanks could look like this:

Assign Activity:

dtCleansed =

(From d in dtData.AsEnumerable
Where not isNothing(d("YourColName"))
Let cv = d("YourColName").toString.Trim
Where not String.IsNullOrEmpty(cv)
Select r = d).CopyToDataTable

For the unhappy case that all rows are empty we would defensive handle like:
:ambulance: :sos: [FirstAid] Handling of The source contains no DataRows exception - News / Tutorials - UiPath Community Forum

We can also adapt the LINQ and add more checks on it

1 Like