8 Replies Latest reply: Mar 23, 2015 6:31 AM by Jason Willcox RSS

    Creating Dummy Entries or Null Counts in Load Script

    Jason Willcox

      Hi There QV experts.

       

      I have a master table where my full data set resides;

       

      MasterTable:

      IDNOS

      Field1

      Field2

      (100 records)

       

      Left Join

           IDNOS

           Field3

      (20 records)

       

      Left Join

           IDNOS

           Field4

      (30 records)

       

      So my resulting dataset is;

       

      IDNOS

      Field1

      Field2

      Field3

      Field4

      (100 records)

       

      My problem

      I want the Field3 in my output to display the text 'NotAvailable' where the IDNOS exists in the MasterTable but not in the data I am using to left join from.

       

      When done I want to be able to count contents of Field3 so that the counts equal 100 not 20 (i.e. so 80 of these will be the count of  'NotAvailable').

       

      Ditto for Field4.

       

      Thanks!

      JW