Get Row Item activity, data table with row names?

Hi,

I am not familiar with data tables with row names and the Get Row Item activity.

  1. How do data tables with row names work?
  2. How do you create a data table with row names?
  3. How do you select individual rows using data table functions?
  4. How do you change the row names?
  5. How do you delete row names?
  6. Brief overview of how Get Row Item activity works?
  7. Any other activities involving row names?

@DEATHFISH

  1. UiPath Data Tables native support the Column Name not the Row Name
  2. Use the first column as the Row Name and loop through it
  3. Try with For Each Row activity, Filter Data Table activity
  4. There is no native support for it, you need to do it manually
  5. see No.4
  6. Gets a value from a DataRow variable according to a specified column.
  7. it seem there is no activity involving row names.

Hi @DEATHFISH

There is no option in UiPath to work with row names. but there is a option to work with Column Names. If you loop through a datatable, you can access column values like Row("ColumnName").ToString

If you are extracting data from a excel, the first row can be considered as the column names. If you are building a datatable using Build Data Table activity, you can specify the names you need in the designer

You can use the For Each Row activity to loop through the datatable rows. In the loop, once you are selected a individual row, you can access its data like Row("ColumnName1").ToString.

There is no support to change row names as rows actually do not have any name. However, we can change column names as required, but you have to do it manually in the source (Build Data table activity/ Source you are getting data to datatable)

As there are no names for rows, I suppose you are referring to columns. You can use Delete Column activities to remove columns from a datatable. In case you need to omit rows from the datatable, you can use datatable functions to filter data. For example, Datatable.Select("Conditions")

Gets a value from a row according to a specified column. Refer this for more info…

Not really, But you can refer to all datatable related functions here…


2 Likes