This transformation only keeps rows where values in the specified column are missing in the specified column of another table.
EXAMPLE
Table 1: Average income and deductions
| Country | Gross income | Disposable income | Compulsory deductions |
|---|---|---|---|
| United States | 56067 | 45582 | 18.7% |
| Ireland | 51218 | 48073 | 6.14% |
| Luxembourg | 55176 | 47716 | 13.52% |
| Australia | 51050 | 42617 | 16.52% |
| Switzerland | 53716 | 48414 | 9.87% |
| Canada | 45896 | 37469 | 18.36% |
Table 2: Some European countries
| Country |
|---|
| Ireland |
| Luxembourg |
| Switzerland |
Objective: Remove the European countries from the first table.
Transformation parameters:
Result:
| Country | Gross income | Disposable income | Compulsory deductions |
|---|---|---|---|
| United States | 56067 | 45582 | 18.7% |
| Australia | 51050 | 42617 | 16.52% |
| Canada | 45896 | 37469 | 18.36% |