The user has an Excel file where column B contains questions, and column C has the "Answer" header. After that, there are thousands of hidden empty columns, and another "Answer" header appears in column XFD. However, when uploading the file, the system does not detect or display the XFD column for configuration.
Excel file:
In import page:
The user’s expectation is that the system will recognize ALL areas of potential input in the source file. Generally, the documents do not allow the columns to be edited or deleted. The columns were all locked which is a common practice for this client. Therefore, the workaround to delete the empty column doesn't work for the client.
Client name: Informatica
Attached a source file used by the client.
Regards,
Karthick | Support Engineer
