generate data in load script

[wade12]

hi,

i have the following table (smal sample below) loaded from and excel sheet.

i need to code it so that whenever someone does not have a value for a date (e.g. mary on 31st aug) then it is assigned zero.

i.e.  i need this:

thank you in advance for your assistance.

have a nice weekend.

[tresesco]

Have a look here:

Generating Missing Data In QlikView

How to populate a sparsely populated field

[wade12]

thanks tresesco.