In the Repository tree view,
expand Metadata and the
FileExcel node
where you have stored the main input schemas and then drop
it onto the design workspace.
A tFileInputExcel component holding your schema
displays on the workspace.
Do the same with the reference input schema to display the
reference tFileInputExcel
on the workspace.
Drop a tBlockedFuzzyJoin and
tLogRow (x3) from
the Palette onto the design
workspace.
Connect the main and reference input Excel files to tBlockedFuzzyJoin using
Main links. The
link between the reference input Excel file and tBlockedFuzzyJoin displays as
a Lookup link on the design
workspace.
Connect tBlockedFuzzyJoin to
the three tLogrow
components using the Matches, Possible
Matches and Non
Matches links.
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!