Hello! When our cager sends us import files for our direct mail gifts, they have the proper "acknowledge" or "do not Acknowledge" coding on them for RE batch. We have to globally apply the proper letter type to those that have "Acknowledge" on them. Is here a way to translate this automatically with IOM - maybe with a virtual field?
over 4 years ago
If all the records that say Acknowledge have the same record type, you could copy the value to a virtual field , and use the virtual field for your letter code. Then you can apply a dictionary to the virtual field to translate Acknowledge to whatever the letter code is.