Configuring a tMap component filter to catch rejects, and exporting to XML

You must have configured a tMap component filter by years (see Configuring a tMap component filter by years).

1. Double-click the tMap component.
2. On the right side of the screen, click Add output table.

   

   1. Enter a name.

      Example

      moviesBefore80s
   2. Click OK.
3. In input table row1, select all columns then drag-and-drop them in output table moviesBefore80s.
4. In output table moviesBefore80s, click tMap settings.
   1. In the Value field of Catch output reject, click [...].
   2. Select true.
   3. Click OK.

      

5. Add a tFileOutputXML component for each of the output tables.
   1. Right-click the tMap component.
   2. Link the tMap component to each of the output components.

      Example

      Select Row > moviesBefore80s.
6. Double-click each tFileOutputXML component.
   1. In File Name, enter the path and name for the output file.

      Example

      moviesBefore80s.xml
7. In the Run view, click Run.

Results

The Catch output reject Property collects all rows of data which do not match either of the other two conditions, meaning all movies from before 1980. In customers_unordered.csv, there is only one: Agnès Varda's Cleo from 5 to 7.