Put a flat file in message shape and the data includes Apostrophe ('). Flat file profile is removing the apostrophe before loading the data.
Message shape interprets characters differently. There are 2 ways to fix this issue.
1. Use a disk connector to retrieve file instead of using message shape.
2. Within message shape, add another apostrophe (') after the existing one. For example, if the original data is [ya'll], you will need to change it to [ya''ll].