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.