So far, we have seen how tMap
can be used to transform and filter input data. But this is only a part of the tMap
functionality. The tMap
component is also the main component used to perform join logic between multiple input sources. This recipe demonstrates the basics of using tMap
to join multiple data sources.
Right-click
tFileInputDelimited
. Go to Row | Main and connect it totMap_1
. Change the name of the flow toorder
.Open
tMap,
and you should see two input tables: customer and order.Select the
customerId
field from thecustomer
table and drag it to thecustomerId
Expr. key
in theorder
table.You will see a purple key icon and a flow showing the linked fields.
Type
"Card"
into theExpr.
key
field fororderType
.Drag all the order fields apart from
customerId
to the output. YourtMap
should now look like the following screenshot:Close
tMap
and run the job.You will see that there is a single row...