Procedure
-
Double-click the tXMLMap
component to open its Map Editor.
An empty Reject output table that carries the rejected data has been added to the output side to represent the output data flow carrying the rejected data.
-
In the
row1
main input table, click theid
node and drop it on the Reject output table. A columnid
is added to the Reject schema table in the Schema editor on the lower part of the map editor. -
Do the same to drop
CustomerName
,CustomerAddress
, andidState
from therow1
main input table andLabelState
from therow2
lookup input table on the Reject output table. Another four columns are added to the Reject schema table in the Schema editor.Tip:In this scenario, the Reject output flow uses the flat data type. However, you can create an XML tree view for this flow similar to the Customer output flow using the Document data type. For further information about how to use the Document type, see Mapping and transforming XML data.
-
On the top of the Reject output table,
click the
button to open the property setting area.
- Set the value of the Catch Output Reject property to true to catch the data rejected by the filter set up in the previous scenario for the Customer output flow.
- Set the value of the Catch Lookup Inner Join Reject property to true to catch the data rejected by the inner join operation.
- Click OK to validate the changes and close the map editor.