How to retrieve previous values

[somersst]

I've the following table

I want to obtain the following :

So I need something in Talend which I can use to calculate the previous weeks. Above is some simplified, because I need to retrieve the last 10 weeks.

[vboppudi]

Hi,

You can try with tMap variables to get your desired output.

Regards,

[somersst]

Hi,

can you provide some more information, because it’s not clear to me how to use this tmap. I use it normaly to do ordinary lookups.

[Anonymous]

Hi,

     A similar issue has been solved by TRF. Could you please refer his post and make suitable changes for your use case?

https://community.talend.com/t5/Design-and-Development/How-to-Perform-Cumulative-in-Talend/td-p/3648...

Warm Regards,

Nikhil Thampi

[TRF]

You can adapt my post as suggested by @nthampi or go with local tMap variables as proposed by @vboppudi.
The second solution is a little more tricky, what you have to know is that these variables keep their value between rows, so you can "see" values from the previous record.

[somersst · Accepted solution]

I've found myself a good solution, making use of the tMemorize component.

I included here some screenshots, that should give you a good idea on the solution