Hello to all,
I have a map that I am working on using Mapper.
I am using the convertCodeFromFile formula to read in a value and output a
different value.
Here is the formula I am using
(convertCodeFromFile("Shippers.txt",TD505, 1, 2)
The formula works, but when a value is received from the TD505 that is not a
part of the "856ship.txt" it causes an error.
I have tried using the following modified formula which works, but produces a
Compliance warning.
convertCodeFromFile("Shippers.txt",TD505, 1, 2)||"NONE"
Any ideas on how to use the convertCodeFromFile formula to output a value when
the value received is not a part of the input value?
Thanks in advance,
Michael Josiah
(aka NY EDI Guy)
