Introduction
This section summarizes the basic fuctions which include the following:
- Comparing two tables
- Checking tables according to rules provided
- Looking up data from other tables
- Combining multiple tables (e.g. merging data)
- Exploring and extracting tables
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
Looking up data from other tables:
table lookup
table lookup ignore case
table lookup top down
table lookup top down ignore case
table lookup once
table lookup once ignore case
table lookup fast
table lookup fast ignore case
table lookup smart
table lookup smart ignore case
table lookup smart once
table lookup smart once ignore case
table lookup with rules
table lookup with rules ignore case
table lookup with rules once
table lookup with rules once ignore case
Looking up data from other tables and integrating their results:
table integrate
table integrate ignore case
table integrate top down
table integrate top down ignore case
table integrate once
table integrate once ignore case
table integrate fast
table integrate fast ignore case
table integrate smart
table integrate smart ignore case
table integrate smart once
table integrate smart once ignore case
table integrate with rules
table integrate with rules ignore case
table integrate with rules once
table integrate with rules once ignore case
Looking up data from other tables, integrate results, add rows in case of multiple matches:
table expand
table expand ignore case
table expand fast
table expand fast ignore case
table expand smart
table expand smart ignore case
table expand fast smart
table expand fast smart ignore case
table expand with rules
table expand with rules ignore case
table expand with rules once
table expand with rules once ignore case
table expand fast with rules
table expand fast with rules ignore case
table expand fast with rules ignore case once
table expand fast with rules once
Looking up data from other tables, integrate results from one or more matching row into target table row:
table digest
table digest ignore case
table digest smart
table digest smart ignore case
table digest with rules
table digest with rules ignore case
table digest with rules ignore case once
table digest with rules once
table describe
table describe ignore case
table describe selected rows
table describe selected rows ignore case
Merge two tables with union-set principle:
table merge
table merge exclusive columns
table merge extend columns
table merge intersect columns
table merge subtract columns
One table overlays the other table, without adding rows:
table overlay
table overlay columns
table overlay exclusive columns
table overlay extend columns
table overlay intersect columns
Row-wise intersection made from two tables:
table intersect
table intersect columns
table intersect exclusive columns
table intersect extend columns
table intersect intersect columns
One table does row-subtraction on other table:
table subtract
table subtract columns
table subtract exclusive columns
table subtract extend columns
table subtract subtract columns
Derive disjoint union (exclusive or) from both tables:
table exclude
table exclude columns
table exclude exclude columns
table exclude exclusive columns
table exclude extend columns
Relational multiplication of two tables:
table multiply
table multiply selected rows
Relational division of two tables:
table divide
table divide selected rows
Arrange multiple tables side-by-side:
table arrange
table arrange with spacing