https://community.qlik.com/t5/Talend-Studio/Equivalent-to-SQL-Server-Lead-and-Lag/m-p/2285845#M59467 For Lead() function you can use tMemorizeRows. <BR />For lag() I'm afraid this is not possible with standard components. You probably will have to proceed by yourself with something like: <BR />- add a column with row number <BR />- sort the result set with this column in reverse order <BR />- use tMemorizeRows (previous row was next one before to reverse the order). <BR />Could be, for huge result sets... Wed, 05 Feb 2020 21:55:03 GMT TRF 2020-02-05T21:55:03Z https://community.qlik.com/t5/Talend-Studio/Equivalent-to-SQL-Server-Lead-and-Lag/m-p/2285844#M59466 <P>Is there component and or code in Talend I could use that's the equivalent to SQL Server Lead and Lag? In a dataset, with Lead and Lag, one is able to get value(s) from a prior or subsequent row.</P> Sat, 16 Nov 2024 03:21:06 GMT https://community.qlik.com/t5/Talend-Studio/Equivalent-to-SQL-Server-Lead-and-Lag/m-p/2285844#M59466 jimbo20814 2024-11-16T03:21:06Z https://community.qlik.com/t5/Talend-Studio/Equivalent-to-SQL-Server-Lead-and-Lag/m-p/2285845#M59467 For Lead() function you can use tMemorizeRows. <BR />For lag() I'm afraid this is not possible with standard components. You probably will have to proceed by yourself with something like: <BR />- add a column with row number <BR />- sort the result set with this column in reverse order <BR />- use tMemorizeRows (previous row was next one before to reverse the order). <BR />Could be, for huge result sets... Wed, 05 Feb 2020 21:55:03 GMT https://community.qlik.com/t5/Talend-Studio/Equivalent-to-SQL-Server-Lead-and-Lag/m-p/2285845#M59467 TRF 2020-02-05T21:55:03Z