ETL does not process certain files correctly

[thecaffiend]

Not entirely sure what's up as the 2 files look very similar (it's a word doc, so looks mean little) with the exception of extra formatting (e.g. extra newlines in the "Dummy Data" file column headers and alert date).

The file GPHL CRE Alert Example.docx is processed as expected yielding the expected clean csv file. The file CRE Alert Dummy Data.docx yields a clean csv with the first 2 rows containing seemingly header data (and they are not the same, so it's not just a duplication of the row), which leads to the downstream data catalog queries including header data as though it was CRE Alert data.

CRE Alert Dummy Data GPHL.docx
GPHL CRE Alert Example.docx