Hubert-Dudek
Databricks MVP

Files saved in Windows operation system contain carriage return and line feed in every line.

Please add following option it can help:

 .option("ignoreTrailingWhiteSpace", true)


My blog: https://databrickster.medium.com/

View solution in original post