12-11-20 03:41 PM
Answered! Go to Answer.
13-11-20 12:51 PM
13-11-20 12:51 PM
16-11-20 09:33 AM
utCollection=inCollection.DefaultView.ToTable(true)
And I'm having the same problem (remove rows with duplicate values).
I try one solution, I wrote it on this page: https://qiita.com/Sumire_Neko/items/26b9d146ab67eaa7ddcf
(This is written in Japanese, so please read it using a translation tool or something)
To filter blank value, how about using len([Column Name])<1 instead of "Name=" & ""
My suggestion may not be helpful, I also want to know how to avoid duplicate values.
22-12-21 09:52 PM
22-12-21 10:05 PM
23-12-21 02:14 AM
Ideally I think this happens because the filter expression most likely doesn't recognize the Blue Prism functions but it works as per the Select method argument of Datatable class in C# or VB .NET framework. It should accept values like:
CONVERT
– converts particular expression to a specified .NET Framework typeLEN
– gets the length of a stringISNULL
– checks an expression and either returns the checked expression or a replacement valueIIF
– gets one of two values depending on the result of a logical expressionTRIM
– removes all leading and trailing blank characters like \r, \n, \t, ‚ 'SUBSTRING
– gets a sub-string of a specified length, starting at a specified point in the stringAND
, OR
and NOT
LIKE
, IN
= <> < <= > >=
SUM,COUNT,MIN,MAX,AVG(average),STDEV
(statistical standard deviation) and VAR
(statistical variance).<DataTable_object>.CaseSensitive = False