Cisco Cisco Process Orchestrator 3.1 User Guide

Page of 786
 
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.
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. 
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. 
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.
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. 
Read Table from XML
Read an XML snippet and convert it into a table with a specified set of 
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.