Cisco Cisco Process Orchestrator 3.1 User Guide
7-3
Cisco Process Orchestrator 3.1 User Guide
Chapter 7 Advanced Authoring Concepts
Using Table Activities
Using Table Activities
You can use Table activities to modify the format for existing defined table variables.
Note
Any boolean and numeric values that are used by the Table activities in the product are not localized.
Numbers use [ . ] for the decimal format regardless of the regional and language options. Boolean values
for substitutable boolean must be true or false regardless of the installed language.
Numbers use [ . ] for the decimal format regardless of the regional and language options. Boolean values
for substitutable boolean must be true or false regardless of the installed language.
For example, you can:
Table 7-1
Sample Table Activities
Activity Type
Purpose
Add Row to Table
Append new rows to a table variable. The row is added to the end of the
table.
table.
This activity will not work on tables that are outputs of other activities.
Analyze Table
Summarize and analyze data in a table variable or property using basic
aggregation functions.
aggregation functions.
Highlight Row
Highlight selected rows of a table variable. Highlighted rows can only
be displayed in an automation summary. Therefore you will not see the
highlighted rows in Process Orchestrator unless you are viewing the
automation summary.
be displayed in an automation summary. Therefore you will not see the
highlighted rows in Process Orchestrator unless you are viewing the
automation summary.
Read Table from Text
Read a comma-separated value (CSV) string variable and convert the
text into a table with a specified set of columns.
text into a table with a specified set of columns.
Read Table from XML
Read an XML snippet and convert it into a table with a specified set of
columns. For example:
columns. For example:
Row XML Element Name:
MyRow
Columns to read:
Name String
Age Integer
Source XML:
<MyData>
<MyRow>
<Name>Jeff</Name>
<Age>32</Age>
</MyRow>
<MyRow>
<Name>Mark</Name>
<Age>31</Age>
</MyRow>
<MyRow>
<Name>Jay</Name>
<Age>30</Age>
</MyRow>
</MyData>
This produces a table with two columns (name, age), with three rows.