filling null records

[#1]

Please See the attached file.

The scenario is that there are four columns client no,date, product and value. In the given  data some dates are missing like  2,4,5,7,8,9/12/2012. the data which i have and my requirements are in attached excel doc.

Thank's in advance

[nirav_bhimani]

Hi,

You have to create inline table n then  do the join.

Regards,

Nirav Bhimani