For most standard User Management tasks, the available built-in tables
(Fixed, Network, Generic) can be used. There are situations however, where
these standard tables may not be sufficient:
You may wish to evaluate an existing table programmatically
and / or create a new table from scratch ;
You may have to combine data from one of the built-in
tables with data which are not contained in a table.
In such cases, you can use the Manage table data script action to create
your own tables. This script action includes many operations for creating
and editing tables:
Available table data operation
Remarks
Create table
Creates an empty table. Initially, the table
contains rows with empty data text fields
Append a row at the end of the table
Adds a row at the end of a table. Initially,
the table row contans empty data text fields. The specified row index
variable contains the index of the new row when the action is executed.
Append a column at the end of the table
Adds a column at the end of a table. Initially,
the table column contans empty data text fields. The specified column
index variable contains the index of the new column when the action is
executed.
Set the data for the specified row and column
of the table
Sets the data value of the specified cell
to the specified value. The cell is specified by the row and column index.
The data cell value can be specified by a text value or variable name.
Get the data at the specified row and column
of the table
Copies the data value of the specified cell
into the value of the specified output variable. The cell is specified
by the row and column index
Get the number of table rows
Determines the number of rows in the table.
The number is stored in the row count variable
Remove duplicate rows
Removes duplicate rows from the table. The
specified key column index is used to find duplicate rows. A duplicate
is found when the cell data of two rows in the specified key column are
equal.
Convert multi-text variable to table
Converts a multi-text variable into a single
column of a table
Log table data
Logs the contents of a table as a variable
Export to .csv file
Exports the table data to a .csv file. You
need to specify the file name, the separator and format string (optional)
Remove duplicate rows
Used to remove duplicate table entries. For tables containing multiple
columns, you need to specify which column is used as the index column.
In other words, which column is used to evaluate if duplicates exist?
Note that the first column in your table is regarded as "column 0",
the second one as "column 1", and so on. Suppose for instance,
that you have a single column table (%Departments%)
with the following entries:
If you now wish to remove the duplicate rows in this table, you need
to specify the following:
Table data operation - Remove
duplicate rows
Table data variable - The variable
containing the table data you want to operate on.
Key column index - relevant
for multi column tables. In that case, you need to specify the column
in which UMRA will look for duplicate entries (0,1,2,3, etc.).
The duplicate rows will be removed, resulting in a single column table
with the entries Helpdesk, Marketing, Administration,
IT.
Convert multi-text variable to table
Log table data
Logs the content of a specified variable to the log window.
Table data operation - Log table
data
Table data variable - The variable
of which you want to log the content. This will appear in the log window.
Export to .csv file
Used to export the contents of a table (contained in a variable) to
a .CSV file.
Table data operation:
Export to .csv file
Table data variable
- The variable containing the table data you want to export to a .CSV
file
Export file - The
name of the export file. If it does not exist yet, it will be created.
Separator - The
column separator to be used
Format string -
Here you can specify if and how column text strings in the CSV file must
be formatted.
