Header: "Field Name" not found in Data

Issue:

While testing the csv file used to create the Text Schema, following error about header not found is shown:
Error found while executing request:
Please refer logs for details.
Header: "Term_Date" not found in Data

This issue appears only when the Dynamic Header Support option is used. If it's not selected, the file is read fine.

Cause:

The Record Separator Definition may not be correct.

Solution:

If your file has CRLF character at the end of the lines, you'll need to define the record separator as \r\n instead of \n.

To check the record separator values, try using Notepad++ to read the file with the Show All Characters option enabled.