Requirement is if value is zero between Quarter need to fill with previous Quarter value.

[lokeshbabu]

Hi All,

Need to solution for below problem

Source
Quarter|PPID|Value

16-Q1|20051|0
16-Q2|20051|8
16-Q3|20051|0
16-Q4|20051|8.5
17-Q1|20051|0
17-Q2|20051|0
17-Q3|20051|0
17-Q4|20051|0
18-Q1|20051|0
18-Q2|20051|9
18-Q3|20051|0
18-Q4|20051|0

Excepted Result

Quarter|PPID|Value

16-Q1|20051|0
16-Q2|20051|8
16-Q3|20051|8
16-Q4|20051|8.5
17-Q1|20051|8.5
17-Q2|20051|8.5
17-Q3|20051|8.5
17-Q4|20051|8.5
18-Q1|20051|8.5
18-Q2|20051|9
18-Q3|20051|9
18-Q4|20051|9

requirement is if value is zero between Quarter need to fill with previous Quarter value.

Please help me out here.

Thanks

Lokesh

[akumar2301]

Hello



Try tmemirizedrow , we can store value in memory and use it after :
https://help.talend.com/reader/mjoDghHoMPI0yuyZ83a13Q/0oEBI6YCTFXSgc5Z9Gpr6Q

Otherwise you can use tmp local variables to store previous record data. And use it accordingly.