Hi Maximilian, There are multiple ways to do this. You'll probably get the closest to what you want to achieve with the Group By transform [1] with the "include all rows" option. If you want to include previous/next rows, you may want to included the Analytic Query transform [2] in your pipelines.
[1] https://hop.apache.org//manual/latest/pipeline/transforms/groupby.html [2] https://hop.apache.org//manual/latest/pipeline/transforms/analyticquery.html Regards, Bart On Tue, Sep 5, 2023 at 4:24 PM Maximilian Leitschuh < [email protected]> wrote: > Hello, > > > > What is the best way to perform something like SQL window functions in > Hop? (https://en.wikipedia.org/wiki/Window_function_(SQL)) > > > > I mean you can execute the SQL-transforms. But are there other ways > without writing SQL-statements to get the same output? > > > > Thanks a lot ! > > > > Best regards, > > Maximilian Leitschuh > HINWEIS: Dies ist eine vertrauliche Nachricht und nur für den Adressaten > bestimmt. Es ist nicht erlaubt, diese Nachricht zu kopieren oder Dritten > zugänglich zu machen. Sollten Sie diese Nachricht irrtümlich erhalten > haben, bitte ich um Ihre Mitteilung per E-Mail oder unter der oben > angegebenen Telefonnummer. >
