Skip to Content
Former Member
Aug 07, 2009 at 01:37 PM

How to handle multiple source fields in message mapping



My source message has the following structure for my source field:


I need to check each of the DAT fields starting from field 1 to field 25 for the first field that contains a value and then map that field value to a single target field. I know this can be done using the available functions in the graphical mapping to check each field one at a time and map the field that contains a value. However, I wanted to know if there is a better way of doing it such as iterating over the total number of fields and accessing each of the field dynamically to determine which contains a value? If this is possible, can you please show me how this can be done?

Thanks in advance for any help.