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

lokeshbabu — Sat, 16 Nov 2024 03:27:53 GMT

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

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

akumar2301 — Sat, 25 Jan 2020 08:14:17 GMT

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.

topic Re: Requirement is if value is zero between Quarter need to fill with previous Quarter value. in Talend Studio

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

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