Use case - A client has reported an issue when a file is uploaded on the Load File activity.
Here are steps are taken to reproduce the issue:
When you refresh to detect a new column, you will see extra characters with the “Email” header.
This can also be seen in COLUMN DEFINITION.
You will also see ID has an i_Email instead of Email.
The issue is related to the file encoding. When files are saved with the UTF-8-BOM encoding, the BOM characters (EF BB BF) are added at the beginning of the file.