Cross Reference Lookup should return the input if no value exists

Document created by Terese_Baker Employee on May 7, 2015Last modified by vreddy on Mar 1, 2016
Version 2Show Document
  • View in full screen mode
If the inbound data does not have a value that is in the cross reference table, the output should be input itself.
A Cross Reference Table lookup is not currently designed for this scenario; however, this can be accomplished in a map by adding a custom scripting step after the Cross Reference Lookup. The custom scripting step should contain an if-else to determine if a result was found in the Cross Reference Lookup and output that result or the inbound data, as appropriate.




3 people found this helpful