1

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
FROM query_154607

The error I get is:
Error running query: near “from”: syntax error

Both column a and b are numbers.

Any suggestions? Thanks

2

Did you mean SELECT a
FROM query_154607
where b=123456?

3

Bumping an old thread to say that we now have documentation discussing this exact use case. Doc page is here.