When trying to use the LAG function from SQLite on an Apply SQL Transformation module from Azure Machine Learning designer results in a error, saying the sintax near "(" was wrong.
The SQL code:
select t1.id, t1.veiculo, lag(t1.id) over (partition by t1.veiculo order by t1.id) id_ant
from t1
Looking at the link below, there is no clue on why I can't use a analytical function from SQLite on the module.
https://docs.microsoft.com/en-us/azure/machine-learning/algorithm-module-reference/apply-sql-transformation
Any tips?