I’m trying to do a basic sort a column with spaces in it, “REC #”, with the following request
Which is not working. It gives the message “Column not found: 1054 Unknown column ‘REC’ in ‘order clause’”. However, if I try to sort columns with no spaces, it works just fine. It seems to be cutting off after the space on the column with the space. Is there any way to get it to work without renaming the column?
EDIT: Solved my own issue! I simply just gave the column an Alias in the schema. Works wonderfully now.