0 Replies Latest reply: Jan 11, 2017 10:20 AM by Ashley Navin RSS

    Bring in Production Date from QVD

    Ashley Navin

      I have created an extract that grabs 3 tables from SQL and concatentates them into a QVD. This extract runs everyday and generates a QVD for that date, so the qvds will begin to accumulate.

      In the Document I bring in all the QVD files. The QVDs are successfully created everyday and there is data in the document, but i want to be able to back-date using the production date that is in the tables. The list of dates are available, but when i select one, all my data disappears, and then when no date is selected, the data is there.

       

      I am not sure if the problem is because the 3 tables I am bringing from SQL server...... 1 table is static data on a hard date that will never be changed that is called 'Initial', so this table does not have a production date attached to it.

      The other two tables just take the max production date available so that is how a new QVD is created for every production date as time goes on.

       

      Is the issue because not all the data points have a production date tied to them? If so, is there a suggestion on how I can have static data and dynamic data mesh together under one production date?