Use the Internal Lookup function to map alternative input values to output data elements, using a lookup table created in the function's interface.
Internal Lookup functions are available as part of the Data Transformation Layer (DTLWhen used as part of a BPA Platform tool, the Data Transformation Layer (DTL) extend the tool's functionality by transforming SML from schema to another. In addition, several transformation functions are available for use with the input data before such data is mapped to the destination schema.) feature.
n Internal Lookup Function
Internal Lookup functions are used in the Mapping tab of the following tools:
|||Run Microsoft Reporting ServicesThe Run Microsoft Reporting Services tool automates the running of Microsoft Reporting Services (MSRS) reports.|
|||Transform DataTransform Data is a Format tool that enables a new structure to be created from an existing XML or recordset data source. The output generated by this tool is ready for use in a destination system which consumes or requires XML.|
|||Web Service Connector|
- Open the relevant task step and go to the Mapping tab.
and — Node or element available for mapping
— Mandatory element that must be mapped and included in the output
- Click Functions to expand the Functions pane.
- Expand the
Lookupnode and drag Internal Lookup to the Transformation Mappings pane.
- Drag the relevant Input Data source node
or elementto the new icon.
- Do the same for the receiving Output Data node
- Double-click the icon.
The Transformation Mappings pane is replaced with the Internal Lookup's configuration pane:
- Enter a meaningful Function Name.
- The input (source) and output (destination) links created previously now appear in the Inputs and Output tabs. If you have more than one connected input or output, it is recommended you Edit each Parameter in turn and rename it.
- To change an existing mapping, either Inputs or Output, use the drop-down lists under Mapped To to select a new node
Creating the Lookup Table
You use the Table tab to create the "translations" between the input and output elements.
- If you haven't renamed the input and output parameters, it is recommended you do so now (Input and Output tabs). This helps identification when adding the values.
- Go to the Table tab.
- Enter the lookup input - output value pairs as required.
Selecting Error Handling Options
Use the Options tab to define error handling behaviour for this function.
At task run-time, if
|||Output an empty String — An empty string is passed to the mapped output node at task run time, for example,
|||Output no Data — The element isn't included in the output XML.|
|||Output Value — Enter a static value in the provided text box; this value is passed to the mapped output at task run-time.|
|||Error — The function logs an error to the BPA Platform Event Log. Depending on the parent task step's own error handling options, the task can either continue or fail completely.|
Click OK to save the function and return to the parent task step's Mapping tab.