Help building up a costs table by period

[hopkinsc]

Hi all,

I need to build a costs table, adding to it each period with a new file.

What i need is to have an existing table of products and costs, then at the start of the next period i will need to laod in an updated file with the next periods data in it, add this to the existing table in QV but with that period number applied. If there are products missing from the latest file, i need it to bring forward the products from the earlier file with the costs, so the resulting table will always have very product in it for every period, but for products that have dropped off the range, the cost would be pulled forward from the last time it appeared.

I have attached some sample files. the QVW also has some additional explanation within the script.

Any help would be great

[sunny_talwar]

So, the cost file won't ever have YearPeriod field? Also, are you planning to store this information in a qvd file?

[hopkinsc]

Yes that's correct for both questions.

The file will be a very basic 2 column file. And I guess the easiest thing to do is store it out each period with the updated values appended.

Get Outlook for iOS<https://aka.ms/o0ukef>

[sunny_talwar]

Make sense, working on it

[sunny_talwar · Accepted solution]

Please find attached

[hopkinsc]

Thanks Sunny, that looks like it could do the job. it looks quite simple too!

i just need to move it to my live doc and get it working!

Did you mange to look at the other one?

[sunny_talwar]

Did you mange to look at the other one?

[sunny_talwar]

Can you share the link to the other post?

[hopkinsc]

Hi Sunny,

Thanks!!

Help with adding in a price change file and using the new prices