Cross reference table example: One input and one output

A cross reference table can be used to accept one input value and produce one output value. The example here shows a cross reference table lookup within a function.

In addition to setting up the function, you need to map all input elements from the source profile to the input values in the function. You also need to map all output values from the function to the output elements in the destination profile.

Cross Reference Lookup dialog example showing a single input and single output

For example, when referring to the U.S. states:

System A uses the State Name value
System B uses the FIPS Alpha Code value

When mapping from System A to System B, you need to translate the State Name value to the FIPS Alpha Code value. The SQL Select statement for the Output_Element would be: SELECT FIPS_Alpha_Code FROM State_Cross-Reference_Example WHERE State_Name = Input_Element. If the State Name=Alabama in System A then the FIPS Alpha Code=AL for System B. "AL" is the value that will be returned in the output.