Can't Find Variable type included in Data Table Example

Help Studio
, ,
1

Hello,

I am using what I learned in this example but can’t find the variable type used:

In the example the variable type displayed in the Variable type column is List.

When I click on the Variable type field this detailed description is displayed:
System.Collections.Generic.List<System.Data.DataRow>

I tried typing both variants into the Browse for types search with no success.

From this example:
Remove Data Row/Column (uipath.com)

Thanks,

Joseph

2

This is a list of datarows. Odd thing to do. A datatable would be better.

3

Hi @worldwynj ,

Could you tell us what was searched and what is required ?

image

4

I read through their example and honestly it seems like it was written by someone with not much experience coding. The steps they have there are an attempt to show how to use the activities, but as an actual process it makes no sense.

5

I am using ‘for each row’ to iterate through a datatable to create a collection of datarows that I wish to delete. I then use ‘for each row’ again to iterate through the collection to delete the identified rows. Very much parallel to the UiPath example.

What is a better way to do this?

Thanks,
Joseph

6

@worldwynj ,

If a Filtered Datatable is the output that is expected based on some conditions, then you could try using the Filter Datatable Activity. Maybe more of a Direct approach than collecting and deleting the identified rows.

We could go for a Linq approach as well if it doesn’t work with the Filter Datatable Activity.

7

Filter Datatable literally does all that in one step. That’s how you’d do it in the real world. Their example is doing it a roundabout way, apparently in an attempt to show some concepts and teach some things.