SQL transforms LAG or LEAD

I tried LAG function in mySQL transform, but it appered to be missing.  Is this correct?

Comments

  • jaeW_at_Onyx
    jaeW_at_Onyx Budapest / Portland, OR 🔴

    Domo uses MySQL 5.6+

    @VERSION for the exact version number.

     

    This version of MySQL predates the implementation of Windowed functions.

     

    You can recreate it using user defined variables.

    https://stackoverflow.com/questions/3333665/rank-function-in-mysql

     

    Without performance tuning in MySQL, you'll probably get faster performance using MagicETL if you start using larger datasets.

    Jae Wilson
    Check out my 🎥 Domo Training YouTube Channel 👨‍💻

    **Say "Thanks" by clicking the ❤️ in the post that helped you.
    **Please mark the post that solves your problem by clicking on "Accept as Solution"
  • If you create a Redshift transform instead of SQL, you can use LAG.  I was shown how to create a Redshift dataflow to get active clients by month using start and end date on the client record. 

This discussion has been closed.