process-mining
2021.10
true
Process Mining
Automation CloudAutomation Cloud Public SectorAutomation SuiteStandalone
Last updated Sep 2, 2024

Datasource attributes

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.



Attribute type

Below is an overview of the different attribute types and their default format settings.

Attribute type

Specification

Boolean

N/A

Date

Format: YYYY-M-D

DateTime

Date format: YYYY-M-D

Time format: h:mm[:ss[[.zzz]]]

Double

Decimal separator: . (dot)

Thousand separator: none

Integer

Thousand separator: none

Text

N/A

Date and DateTime attribute types

For attributes of type Date a Date format and attributes of type DateTime a Date format and a Time format are specified. You can select a different format from a list of predefined formats. See the illustration below.



Custom date format

If the datasource attribute you want to load uses a format that is not predefined, you can select the option custom date format. A popup dialog is displayed where you can enter the desired format. See the illustration below.



Below is an overview of the characters that you can use to specify a custom date or a time format.

Character(s)

Description

yor yy

Years

m or mm

Months

wor ww

Weeks

d or dd

Days

h, hh, or hhh
Hours, where hh includes a leading zero.
n, nn, or nnn
Minutes, where nn includes a leading zero.
s, ss, or sss
Seconds, where ss includes a leading zero.
zor zzz
Milliseconds, where zzz includes a leading zero.

{

An optional string that is only printed if the preceding value is not null.

For example yy{y }mm{m }ww{w }dd{d }hhh{h }nn{n }sss{s }. See the illustration below.


  • Datasource attributes
  • Attribute type
  • Date and DateTime attribute types

Was this page helpful?

Get The Help You Need
Learning RPA - Automation Courses
UiPath Community Forum
Uipath Logo White
Trust and Security
© 2005-2024 UiPath. All rights reserved.