Loadscript Table Manipulation - Help Needed

[#1]

Hi,

I am currently having a few issues over the manipulation of a table. The dataset I have has a reference number, various cost coulmns and the date which a cost value has been altered. Where a value has not been altered the value will be 0.

I am trying to backfill each line of data with the current costs for each field so that each line has a complete dataset. I need to do this within the loadscript.

I have attached an example to help illustrate what I mean.

Many thanks in advance.

[#2]

Hi Ted,

attached is a little example file with your data that i think solve the problem that you have.

Hope that helps.

[#3]

stefan,

Many thanks for your response, I have tried this within the excel file and it works perfectly. However, when I have applied it to my application it only seems to produce a duplicate of the column I am looking to fill.

Any ideas?

I am applying this within a resident table, would this cause an issue?

Many thanks

[#4]

Stefan,

I have just done some more testing, the database that I use contains hundreds of 'ref' numbers (line of data will all be mixed, some may only be updated once or twice in a year, other maybe every week),

When I isolate the load to only include one set of 'ref' numbers, the script you supplied works. When I include multiple 'ref' numbers; it then when the column just appears to duplicate.

[#5 · Accepted solution]

Ted,

did the table on which you apply the script is ordered by 'ref' column? Because other way the script will not work as you expect. Try to order the table on 'ref' before the resident table.

[#6]

Stefan,

Many thanks for your help on this, it works perfectly.