Creating duplicate records when loading from .DBO

Thu, 05 Nov 2009 18:55:29 GMT

I want to be able to load records from a contracts database and create a record for each time an invoice will be generate over the next year.

e.g. Database as follows:

Contract Number Invoice Every (months) Last Invoiced

Contract 1 3 31/12/2009

Contract 2 6 31/10/2009

Contract 3 9 31/10/2009

New table should show for first contract, same principle for the second and third contracts

Contract 1 3 31/12/2009

Contract 1 3 31/03/2010

Contract 1 3 30/06/2010

Contract 1 3 30/09/2010

Contract 1 3 31/12/2010

I think the way to do it is to read each record line by line, decide if a new record is needed, if so create a duplicate and change the last invoice date.

I can not find a way to create a duplicate record. Can any one give me any tips on this.

Thank you

Creating duplicate records when loading from .DBO

Thu, 05 Nov 2009 19:31:21 GMT

Hi Adrian,

here are a quick shot.

Hope you are back on track now!

Good luck!!!

Rainer

Creating duplicate records when loading from .DBO

Thu, 05 Nov 2009 21:04:48 GMT

Thank you I will give it a try,

topic Creating duplicate records when loading from .DBO in QlikView

Creating duplicate records when loading from .DBO

Creating duplicate records when loading from .DBO

Creating duplicate records when loading from .DBO