Exporting the results of a tMap component inner join

After configuring a tMap component join model (see Configuring a tMap component join model), you can export it to a delimited file.

Before you begin

You must have joined two data sources (see Configuring a tMap component to join two data sources).
You must also have configured a tMap component join model (see Configuring a tMap component join model).
Begin by removing the tLogRow component added previously and connecting the tFileOutputDelimited component to the tMap component instead.

Double-click the tMap component.
On the right side of the screen, click Add output table.
1. Enter a name for your output table.
  Example
  joinRejects
2. Click OK.
In input table row1, select all columns then drag-and-drop them in output table joinRejects.
In output table joinRejects, click tMap settings.
1. Under Catch lookup inner join reject, click [...].
2. Select true.
3. Click OK.
In the Designer, add a tFileOutputDelimited component.
Right-click the tMap component.
1. Select Row > JoinRejects.
2. Click on the tFileOutputDelimited component to link the two.
Double-click the tFileOutputDelimited component.
In File Name, enter the path and name for the output file.
Optional: Select Include Header.
In the Run view, click Run.

Talend Studio exports two files: one with films that have a directorID, and who that director is, and another with the movies without a directorID.

If you find any issues with this page or its content – a typo, a missing step, or a technical error – please let us know!