Data comes from csv file. First raw is the column names, the rest is data.
Transformation goes like this:
- take data from csv
- promote first raw to header
- change Date column to date/time type
This worked fine, until yesterday. I got the error: "Column Date can not be found" although it is visible in the query and obviously taken from the csv file.
I haven't changed anything. People say it is due to csv change, but in csv the names are as they were.