Procedure
-
Double-click tExtractXMLField to open
its Basic settings view.
- Click the [...] button next to Edit schema to open the schema editor.
- Add two columns to define the structure of the output data: name and price.
- Click OK to close the schema editor, and then click Yes in the Propagate dialog box.
-
In the Loop XPath query field, enter
result between quotes on which the loop
is based.
Each result of the stored procedure has the following syntax:
<result><col0>val1</col1>...<colN>valn</colN></result>
(wherecolN
is the nth column in theSELECT
clause).Warning:If a null value exists in a data record to be returned by the execution result of the stored procedure, some inconsistencies will occur between the column number and the value for this column in the returned data record.
- In XPath query column of the Mapping table, enter the exact node name on which the loop is applied: col0 and col1, respectively, between quotes.