Creating dummy records for missing data in a table
I have the following table:
Load Date, INSTITUTIONAME, INTSANS, SL1, SLA
FROM [lib://myqvd.qvd] (qvd)
There are some INSTITUTIONNAME & Date combinations that won't always populate records for a given day Ion these dates I would still like records and have the SL1 field and INTSANS field to populate zeros so I have dummy records in order to populate a pivot table with accumulative sums. How would I create dummy records in this case? Thank you.