Query on CSV not recognizing column header name

Take a look at this post where I show how to handle column names changing in appending csv files:

Also, in your Source step you can remove the “Columns = xx”. It’s not needed and can lead to problems in my view.