Introduction to table items

Introduction

When a data file is uploaded, a table is created in the application. In the right panel on the Data tab the table items of the selected table are listed. In UiPath Process Mining, there are several ways to enrich your data using table items.

To keep your application cleaned and organized you can create folders of tables and table items.

Table item properties

Table items are defined by properties. Below is a description of the general properties for table items.

Property	Description
Name	• Is visible in the developer environment as well as for the end user; • Can contain multiple words; • Does not need to be unique; • For example, Supplier type.
ID	• Is only visible in the developer environment; • May not contain spaces; • Must be unique in the table to which it belongs; • Can be used in table items to refer to other table items; • For example, Supplier_type.
unique identifier, or UID	• Is generated automatically; • Is uniquely defined over the whole application; • Is used to reference attributes (and not their values) in selectors and switches.

A table can contain several types of table items.

Datasource attributes

Initially the table only contains datasource attributes. Each datasource attribute corresponds to one of the columns in your data file. You can see the attribute details in the Edit Datasource Attribute window.

You can open the Edit Datasource Attribute window in the following ways:

• Double-click on the datasource attribute table item;

• Right-click on the datasource attribute table item and select Edit... from the context menu.

  Note: This also applies to table items of the other table item types.

The Edit Datasource Attribute window shows the following information:

• The Name in data source and the Attribute type. • The Number of unique values and the Total number of records. • A preview of the values Value (Integer) and their Frequency.

See illustration below.

Values context menu

When you right-click in the Values panel, a context menu is displayed. See illustration below for an example.

Below is a description of the options of the context menu.

Option	Description
Use display format	Enables you to show a preview of how the attribute value will be displayed when used.
Use frequency percentage	Enables you to change the Frequency number to a percentage.

Note: In the context menu the table from which you opened the Edit (Datasource) Attribute dialog is indicated by a checkmark in front of the table name. The values displayed in the Values panel are retrieved from the selected table. In case of a join attribute or a union attribute the attribute resides in multiple tables. To check the attribute values from a different table you can select a desired table.

Searching table items

In the UiPath Process Mining developer environment the search function is available. Click on the Search icon at the top of the table item list and start typing the name of the table item that you are looking for. See illustration below for an example.

When you have multiple types of items in your application, you can effectively look for them by starting your search query with the item type. For instance, by typing Filter only the filters will be displayed.

Changing the color scheme of a table item

You can change the color scheme for attributes, expressions, and maps. Follow these steps to change the color scheme of a table item.

Step	Action
1	Go to the Data tab.
2	In the table item list, double-click on the item for which you want to change the color scheme.
3	Click on ADVANCED... in the Edit Datasource Attribute dialog.
4	Go to the Palettes tab.
5	Select the palette you want want to assign to the selected attribute and click on OK (2x).

See illustration below.

Defining the column width for a table item

For table items that have wide values, the text displayed in charts can become (partly) invisible if the column

is too small to display the complete text. It is possible to specify a column width for a table item. When the table item is used as a text column on a chart, the column width is used as the minumum width for the column. Follow these steps to define the column width for a table item.

Step	Action
1	Go to the Data tab.
2	In the table item list, double-click on the item for which you want to change the color scheme.
3	Click on ADVANCED....
4	Go to the Advanced tab.
5	Click on 0 next to Column width (px) and enter the desired column width in pixels.
	Click on OK (2x).

See the animation below for an example.

When the Column width (px) is set 0 the column width is determined automatically.

Related iformation

See Metrics.

See Filters.

See Expressions.

See Maps.