Alteryx In-Database Tool Does Not Appear to Support SQL WHERE clause

Question

Hello Community,

I am trying to apply the SQL 'where' clause with the In-Database tool as follows:

race_year = 2019
where circuit_id < 70

However, the SQL clause doesn't appear to be supported.

Any thoughts on how to implement T-SQL in the In-Database tool

DataNath · Accepted Answer

@carltonp the In-DB Filter tool itself acts as a 'WHERE' clause and so you just type into the filter everything you would normally place after this. Judging from your request your custom filter should perhaps just be

race_year = 2019
AND
circuit_id < 70

https://help.alteryx.com/20221/designer/filter-db-tool