Example Data

This example shows two data sets being compared, and the data set that is output by the Compare stage.

This example shows two data sets being compared, and the data set that is output by the Compare stage when it has compared them.

This is the first data set:

Table 1. First data set
bcol0 bcol1 bcol2 bcol3 bcol4
0 0 0 0 a
1 7 1 1 b
2 2 2 2 c
3 3 3 3 d
4 5 4 4 e
5 2 5 5 f
6 6 6 6 g
7 7 7 7 h
8 8 8 8 i
9 9 9 9 j

This is the second data set:

Table 2. Second data set
bcol0 bcol1 bcol2 bcol3 bcol4
0 0 0 0 a
1 1 1 1 b
2 2 2 2 c
3 3 3 3 d
4 4 4 4 e
5 5 5 5 f
6 6 6 6 g
7 7 7 7 h
8 8 8 8 i
9 9 9 9 j

The stage compares on the Key columns bcol1 and bcol4. This is the output data set:

Table 3. Output data set
Result First Second
  bcol0 bcol1 bcol2 bcol3 bcol4 bcol0 bcol1 bcol2 bcol3 bcol4
0 0 0 0 0 a 0 0 0 0 a
2 1 7 1 1 b 1 1 1 1 b
0 2 2 2 2 c 2 2 2 2 c
0 3 3 3 3 d 3 3 3 3 d
2 4 5 4 4 e 4 4 4 4 e
-1 5 2 5 5 f 5 5 5 5 f
0 6 6 6 6 g 6 6 6 6 g
0 7 7 7 7 h 7 7 7 7 h
0 8 8 8 8 i 8 8 8 8 i
0 9 9 9 9 j 9 9 9 9 j