Lead and Lag function in Talend ?

One Star

Lead and Lag function in Talend ?

How to implement analytical Lead and Lag functions in Talend ?
If anyone has any idea about it. Please let me know the approach..
Thanks!
Sixteen Stars

Re: Lead and Lag function in Talend ?

First of all, you are able to make use of relevant functions available in the database you are using for your data (.....if your data is coming from a database). If you are using Oracle, for example, you can simply use their analytical functions in your source. However, if this must be implemented in Talend, it can be done as in this mini tutorial.....
https://www.rilhia.com/quicktips/quick-tip-compare-row-value-against-value-previous-row
This is rather limited, but prevents the need to load all of the data into memory. If you are happy with doing that, you can use the tHash components to achieve this.