XML Node to Dataset Action
<AMXMLNODEITERATOR XPATH="text" RESULTDATASET="theDataset" />
Creates a dataset of node values, node attribute values or unique XPaths from the selected node. The dataset's Value property contains the selected values.
Specifies the Xpath Expression from the current XML document to use to evaluate a value.
Specifies the name of the dataset to in which to populate with the node values.
Specifies the session name to identify the in-memory XML document to use in subsequent XML steps. This allows several in-memory XML documents to be active simultaneously.
Specifies the type of information to populate the dataset with.
The available options are:
Text value of each node (default)
Value of a specific attribute (requires entry of the specific attribute)
XPath expression of each node
This action includes the Description tab for entering a custom step description.
More on setting custom step description
This action also includes the standard Error Causes and On Error failure handling options/tabs.
More on Error Handling Options
All text fields allow the use of expressions, which can be entered by surrounding the expression in percentage signs (example: %MYVARIABLE%, %Left('Text',2)%). To help construct these expressions, you can open Expression Builder from these fields by pressing F2.
More on variables
More on expressions
More on the expression builder
NOTE: The code below can be copied and pasted directly into the Steps pane of the Task Builder.
<AMXMLNODEITERATOR XPATH="sum(//price/text())" RESULTDATASET="theDataset" VARVALUETYPE="XpathValue" />