Delete Null Row with in a given field (DateTime format)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
28-10-22 07:46 AM
I have a field which is DateTIme format and has some Null rows. I tried to use "Remove Null Rows" action from
"Utility Collection Manipulation" VBO but it throw's an error.
System.Data.EvaluateException: Type mismatch in function argument: Trim(), argument 1, expected System.String.
Can anyone suggest how to delete null rows from a DateTime field?
------------------------------
vinod chinthakindi
------------------------------
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
28-10-22 08:50 AM
You could use the 'Filter Collection' action in the 'Utility - Collection Manipulation' object to filter only rows which contain a date greater than the earliest possible date. For example, filter rows where the DateTime column value is greater than 1900-01-01 00:00:00. For example:
[DateTime Field Name] > #1900-01-01 00:00:00#
This would remove the rows containing NULL values in the DateTime column.
------------------------------
Carl Carter
Senior Developer
Blue Prism
Europe/London
------------------------------
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
08-11-22 09:51 AM
------------------------------
vinod chinthakindi
------------------------------
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
08-11-22 09:55 AM
------------------------------
vinod chinthakindi
------------------------------
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
16-11-22 10:06 AM
------------------------------
vinod chinthakindi
------------------------------
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
16-11-22 03:01 PM
Hi Vinod,
A Flag data item is aligned to the .NET Boolean data type, therefore it's value can only be equal to True or False.
If you pass a Flag data item into a Code Stage and the current value of this data item has not been set to True or False, then the Code Stage will default the value to False.
You can Loop the Collection outside of a Code Stage and text the length of the column value. If the value in the Collection has not been initialized, and therefore appears to be null, then the length would equal 0.
Len([CollectionName.FieldName]) = 0
You can then remove the row from the Collection using the Collections - Internal Business Object.
------------------------------
Carl Carter
Senior Developer
Blue Prism
Europe/London
------------------------------
