When you read an Excel file with hidden corruption, formatting errors, or encoding issues, the fields might return blank or null values.
Workaround: To resolve this issue, perform the following steps:
1Open the Excel file.
2Save the file without making any changes.
When you resave the file, Excel removes hidden corruption, formatting errors, and encoding issues.
3Use the resaved file as the source object for your mapping.
Source object returns inaccurate header and field values
When you read a .xlsx file generated by certain tools, the headers and field values might be incorrect due to hidden metadata or improper formatting.
Workaround: To prevent processing errors caused by system-generated encoding, adhere to the following data preparation standards:
- Manually resave any generated file before you use it as a source object to eliminate incompatible metadata and encoding errors.
- Convert files to CSV in UTF-8 encoding format. Informatica Intelligent Cloud Services recommends CSV in UTF-8 encoding to eliminate parsing inconsistencies found in standard XLSX files.
- Remove merged cells, hidden formatting, and special encoding by saving the file in a standard, flat format.