3 Replies Latest reply: Mar 19, 2015 8:41 AM by David Edwards RSS

    How do you validate number of records imported against the data source record count?

    David Edwards

      All,

       

      I'm having some difficulty in validating the number of records I have imported into a .QVW against a count of the records from the data source.

       

      Here is what I have so far:

       

      RecordTotal:

      LOAD

           RowCtr;

      SELECT COUNT(*) AS RowCtr

      FROM "testdb".dbo."test_table";

       

      ImportedRecords:

      LOAD

           FieldA,

           FieldB,

           FieldC,

           FieldD;

      SQL SELECT

           FieldA,

           FieldB,

           FieldC,

           FieldD

      FROM "testdb".dbo."test_table";

       

      Let vSQLRecordCt = RowCtr;

      Let vQVRecordCt = NoOfRows('ImportedReocrds')

       

      If $(vSQLRecordCt) = $(vQVRecordCt) Then

           Set vRecordCtValidation = 'Imported vs data source record counts match - extract process complete.';

      Else

           Set vRecordCtValidation = 'Imported vs data source record counts do not match - Admin attention is required.';

      End If

       

      Trace $(vRecordCtValidation)

       

       

       

      It seems that my code is having a problem debugging at the If.. Then.. statement.  I have tried a bunch of different combinations to try to feed to a variable the SELECT COUNT(*) result, but can't seem to find the proper way to do it.

       

      Thanks in advance for the feedback.