Six Stars

How to fill missing date value with the previous date max value using talend

How to populate missing dates with the value of previous date say for example

25-11-2017 1000

27-11-2017 2000

the missing date is 26-11-2017 how to fill it up with 25-11-2017 value using talend

1 REPLY
Twelve Stars

Re: How to fill missing date value with the previous date max value using talend

I have written an example of how to do this using Talend 6.4. It is attached here. You will need to modify it to fully accommodate your requirements. You will need to modify it to (for example) handle multiple customers. However, the complicated work has been done. It uses row multiplication to create rows for the gaps in the days. Have a play and see how it goes.

Rilhia Solutions