Extracting data of interest from the normalized XML data
This section presents the second step of this scenario. Four components are added to receive the normalized XML data in place of the tLogRow component which was set for this action in the first step. The four components are:
-
tExtractXMLField: this component reads an input XML field and extracts desired data;
-
tFilterRow: this component filters input rows by setting conditions on the selected columns;
-
tLogRow (two times): the two components receive and display respectively the valid or invalid data against conditions set in tFilterRow.
To replicate the second step, proceed as the following sections illustrate.