Based on the previous scenario, this scenario shows how to use a lookup flow to join data of interest in the XML file USState.xml to the main flow. Another tFileInputXML component is added to the Job to load data from the lookup file USState.xml to the processing component tXMLMap.
The content of the XML file USState.xml is as follows:
<?xml version="1.0" encoding="ISO-8859-15"?>
<USStates>
<States>
<idState>1</idState>
<LabelState>Alabama</LabelState>
</States>
<States>
<idState>2</idState>
<LabelState>Connecticut</LabelState>
</States>
<States>
<idState>3</idState>
<LabelState>Ohio</LabelState>
</States>
<States>
<idState>4</idState>
<LabelState>Wyoming</LabelState>
</States>
<States>
<idState>5</idState>
<LabelState>Hawaii</LabelState>
</States>
</USStates>