Comparing and Validating Tables

Prev Next

Introduction

The functions described next provide efficient means to check tables for consistency and duplications as well as a simple-to-use function to compare tables and generate comparison reports.


Procedures and Functions Provided:


Compare two tables:
    table compare
    table compare ignore blanks
    table compare ignore both
    table compare ignore case
    [This is a user-defined function you need to create]

Validation functions:
    table validate
    table check duplicates
    table check duplicates ignore blanks
    table check duplicates ignore blanks selected rows
    table check duplicates ignore case
    table check duplicates ignore case selected rows
    table check duplicates ingore both
    table check duplicates ingore both selected rows
    table check duplicates selected rows