Populating Blank fields in Load Script

[mazacini]

HI

I am loading a table with the following fields

SORDREF

ITEMCODE

DATE

I am getting blank DATE fields.

In some cases, the one order will have a blank DATE field for one ITEMCODE, and a present DATE field for another ITEMCODE for that SORDREF.

The DATE field for all line items within the SORDREF will, if present, be the same.

I would like to modify my LOAD script so that in the event of a blank DATE field, it will check other line items for that SORDREF and return that date, or else it will return the date of the previous SORDREF record.

Finally, my LOAD script which loads from a csv file, has a WHERE clause which ignores DATE fields < 31/12/2009. This may have the effect of excluding records with blank DATE from the LOAD. I'm not sure and would like any suggested solutions to address that.

Have tried peek and previous, without sucess - may not be using correctly.

Joe

[matt_crowther]

Could you post an example of the .qvw as it should be possible to sort this in the load script using the previous() function and some sorting of tables as required.

All the best,

Matt - Visual Analytics Ltd

[mazacini]

Hi Matt -

Never did that before. Can you advise how I go about doing it?

Joe

PS - am Personal Edition user, so will not be able to view any amended qvw files.

[mazacini]

Hi Matt

File attached.

Joe