Table vs SQL Data Flows and which functions does Domo not recognize? (I'm confused)

CTBH
edited March 2023 in SQL DataFlows

Hi,

My CSM informed us that window functions are enabled. I would like to write the following via ETL, or a My SQL dataflow (either way is fine), but I don't know whether to pick a Table or SQL transform, and either one I pick will not accept the following statement.


SELECT *,

sum(a) over (partition by b order by a range between unbounded preceding and current row) 

from my table


What I am ultimately trying to do is create a running sum that resets to 0 when it gets to 30 like in the attached dataset. Like in the attached sample.


Answers

  • The version of MySQL (5.6) that Domo is on doesn't support window functions so you won't be able to do that in a MySQL dataflow. You can do unbounded preceeding and current row within a Magic ETL 2.0 dataflow using the Rank and Window tile to do what you're wanting to do.

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**