Double-click the tMap component to open
the Map Editor and do necessary fields
reorganization and concatenation.
In the Map Editor, click the plus button
in the upper-right corner to open a dialog box where you can give a name to
the new output table, regex in this scenario.
This will create a new link in the tMap component
holding the same name and that you can use to connect
tMap to the next component.
In the lower-right corner of the map Editor, click the plus button to
define the fields in the regex output table.
In the upper half of the Map Editor, drop fields from the input
table to fill the fields of the output schema as necessary. For more information
regarding data mapping, see Mapping data flows.
In this scenario, we want to concatenate the Matches, and Non-Matches
fields from the incoming data flow in one output column: Purpose.We want
as well to have a new column in the output schema called Path. And finally, we
do not want to have any rating-related information in the output schema.
Click Ok to validate and close the Map
Editor.
Right-click tMap and select the regex link to connect tMap to tFileOutputDelimited.
Did this page help you?
If you find any issues with this page or its content – a typo, a missing step, or a technical error – please let us know!