Configuring tExtractXMLField to extract data from the returned execution
result of the stored procedure
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>
(where colN is the nth column in the
SELECT clause).
Information noteWarning:
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.
Did this page help you?
If you find any issues with this page or its content – a typo, a missing step, or a technical error – please let us know!
