I am using a csv file as a datasource. First I created a datasource as CSV (from URL) to retrieve the csv file. Then I created a second datasource as a QUERY RESULTS. I created a new query and chose the QUERY RESULTS datasource In the csv file I have 2 columns, labelled a and b. I would like to find the value in column a for a particular value in column b. The syntax I have tried is:
SELECT a where b=123456
The error I get is:
Error running query: near “from”: syntax error
Both column a and b are numbers.
Any suggestions? Thanks