I have a mapping problem. I simply don’t know how to do it. Maybe you could help out or point me to a good article that teaches how to use the mapper.
I have two messages, one message is from a flatfile (MessageA) and another message is from a database (MessageB). Now, MessageA has two columns (Code1 and Code2). MessageB has (ID, CodeIndex). I want to join these two messages into one and insert into a database table. The target table is (ID, Code). So depending on CodeIndex from MessageB, I either join Code1 or Code2. Here’s sample data.